GET https://dev.analizy.uz/news/konsultatsiya-semeynogo-vracha-

Query Metrics

5 Database Queries
5 Different statements
2.78 ms Query time
0 Invalid entities
26 Managed entities

Queries

Group similar statements

# Time Info
1 0.57 ms
SELECT d0_.company_name AS company_name_0, d0_.company_address AS company_address_1, d0_.company_inn AS company_inn_2, d0_.license AS license_3, d0_.license_date AS license_date_4, d0_.name AS name_5, d0_.activity AS activity_6, d0_.id AS id_7, d0_.code AS code_8, c1_.password AS password_9, c1_.receiver AS receiver_10, c1_.type AS type_11, c1_.ip AS ip_12, c1_.port AS port_13, c1_.full_name AS full_name_14, c1_.full_address AS full_address_15, c1_.work_time AS work_time_16, c1_.station AS station_17, c1_.city AS city_18, c1_.bus AS bus_19, c1_.metro AS metro_20, c1_.minibus AS minibus_21, c1_.point AS point_22, c1_.disabled_discounts AS disabled_discounts_23, c1_.id AS id_24, c1_.created AS created_25, c1_.modified AS modified_26, c1_.sort AS sort_27, c1_.activity AS activity_28, c1_.image AS image_29, c1_.single_file AS single_file_30, c1_.lis_id AS lis_id_31, d0_.type AS type_32, d0_.price_customer_id AS price_customer_id_33, d0_.main_customer_id AS main_customer_id_34 FROM domains d0_ LEFT JOIN customers c1_ ON d0_.main_customer_id = c1_.id WHERE (d0_.code = ?) AND d0_.type IN ('DEFAULT_DOMAIN', 'LPU_DOMAIN')
Parameters:
[
  "dev.analizy.uz"
]
2 0.31 ms
SELECT d0_.company_name AS company_name_0, d0_.company_address AS company_address_1, d0_.company_inn AS company_inn_2, d0_.license AS license_3, d0_.license_date AS license_date_4, d0_.name AS name_5, d0_.activity AS activity_6, d0_.id AS id_7, d0_.code AS code_8, d0_.type AS type_9, d0_.price_customer_id AS price_customer_id_10, d0_.main_customer_id AS main_customer_id_11 FROM domains d0_ WHERE (d0_.code = ?) AND d0_.type IN ('DEFAULT_DOMAIN', 'LPU_DOMAIN')
Parameters:
[
  "dev.analizy.uz"
]
3 1.14 ms
SELECT n0_.stock AS stock_0, n0_.title AS title_1, n0_.text AS text_2, n0_.time AS time_3, n0_.header_second AS header_second_4, n0_.header_three AS header_three_5, n0_.header_four AS header_four_6, n0_.text_second AS text_second_7, n0_.text_three AS text_three_8, n0_.text_four AS text_four_9, n0_.activity AS activity_10, n0_.code AS code_11, n0_.image AS image_12, n0_.single_file AS single_file_13, n0_.id AS id_14, n0_.created AS created_15, n0_.modified AS modified_16, a1_.activity AS activity_17, a1_.name AS name_18, a1_.synonym_rus AS synonym_rus_19, a1_.synonym_eng AS synonym_eng_20, a1_.description AS description_21, a1_.indications AS indications_22, a1_.popular AS popular_23, a1_.methods AS methods_24, a1_.bms AS bms_25, a1_.training AS training_26, a1_.id AS id_27, a1_.code AS code_28, a1_.lis_id AS lis_id_29, i2_.price AS price_30, i2_.max_duration AS max_duration_31, i2_.duration_units AS duration_units_32, i2_.disallow_discount AS disallow_discount_33, i2_.id AS id_34, a1_.panel AS panel_35, a1_.analysis_group_id AS analysis_group_id_36, i2_.analyse_id AS analyse_id_37, i2_.customer_id AS customer_id_38 FROM news n0_ LEFT JOIN news_analyses n3_ ON n0_.id = n3_.news_id LEFT JOIN analyses a1_ ON a1_.id = n3_.analyses_id AND a1_.panel IN ('a', 'ap') LEFT JOIN import_prices i2_ ON a1_.id = i2_.analyse_id AND (i2_.customer_id = ?) WHERE n0_.code = ? AND n0_.stock = ? AND n0_.activity = 1
Parameters:
[
  21
  "konsultatsiya-semeynogo-vracha-"
  0
]
4 0.46 ms
SELECT n0_.stock AS stock_0, n0_.title AS title_1, n0_.text AS text_2, n0_.time AS time_3, n0_.header_second AS header_second_4, n0_.header_three AS header_three_5, n0_.header_four AS header_four_6, n0_.text_second AS text_second_7, n0_.text_three AS text_three_8, n0_.text_four AS text_four_9, n0_.activity AS activity_10, n0_.code AS code_11, n0_.image AS image_12, n0_.single_file AS single_file_13, n0_.id AS id_14, n0_.created AS created_15, n0_.modified AS modified_16 FROM news n0_ WHERE n0_.activity = 1 AND n0_.stock = ? AND n0_.id <> ? ORDER BY n0_.id DESC
Parameters:
[
  0
  12
]
5 0.30 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.h1 AS h1_3, t0.url AS url_4, t0.keywords AS keywords_5, t0.id AS id_6 FROM seo_template t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "/news/konsultatsiya-semeynogo-vracha-"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\News 7
App\Entity\Abstracts\Analyses 6
App\Entity\Dictionaries\AnalysisGroups 5
App\Entity\Dictionaries\Prices 5
App\Entity\Customer 2
App\Entity\Abstracts\Domain 1