Symfony Profiler

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')

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 = 'click.dev.analizy.uz') AND d0_.type IN ('DEFAULT_DOMAIN', 'LPU_DOMAIN');

SELECT
  a0_.activity AS activity_0,
  a0_.name AS name_1,
  a0_.synonym_rus AS synonym_rus_2,
  a0_.synonym_eng AS synonym_eng_3,
  a0_.description AS description_4,
  a0_.indications AS indications_5,
  a0_.popular AS popular_6,
  a0_.methods AS methods_7,
  a0_.bms AS bms_8,
  a0_.training AS training_9,
  a0_.id AS id_10,
  a0_.code AS code_11,
  a0_.lis_id AS lis_id_12,
  a1_.activity AS activity_13,
  a1_.name AS name_14,
  a1_.synonym_rus AS synonym_rus_15,
  a1_.synonym_eng AS synonym_eng_16,
  a1_.description AS description_17,
  a1_.indications AS indications_18,
  a1_.popular AS popular_19,
  a1_.methods AS methods_20,
  a1_.bms AS bms_21,
  a1_.training AS training_22,
  a1_.id AS id_23,
  a1_.code AS code_24,
  a1_.lis_id AS lis_id_25,
  i2_.price AS price_26,
  i2_.max_duration AS max_duration_27,
  i2_.duration_units AS duration_units_28,
  i2_.disallow_discount AS disallow_discount_29,
  i2_.id AS id_30,
  a3_.id AS id_31,
  i4_.name AS name_32,
  i4_.id AS id_33,
  i4_.code AS code_34,
  i4_.lis_id AS lis_id_35,
  a0_.panel AS panel_36,
  a0_.analysis_group_id AS analysis_group_id_37,
  a1_.panel AS panel_38,
  a1_.analysis_group_id AS analysis_group_id_39,
  i2_.analyse_id AS analyse_id_40,
  i2_.customer_id AS customer_id_41,
  a3_.type AS type_42,
  a3_.parent_id AS parent_id_43,
  a3_.biomaterial_id AS biomaterial_id_44,
  a3_.container_id AS container_id_45,
  a3_.analyse_id AS analyse_id_46,
  i4_.container_id AS container_id_47
FROM
  analyses a0_
  LEFT JOIN analyses_analyses a5_ ON a0_.id = a5_.analyses_source
  LEFT JOIN analyses a1_ ON a1_.id = a5_.analyses_target
  AND a1_.panel IN ('a', 'ap')
  LEFT JOIN import_prices i2_ ON a0_.id = i2_.analyse_id
  AND (i2_.customer_id = 21)
  LEFT JOIN analyse_biomaterials a3_ ON a0_.id = a3_.parent_id
  AND a3_.type IN ('bm', 'pbm')
  LEFT JOIN import_biomaterials i4_ ON a3_.biomaterial_id = i4_.id
WHERE
  (
    a0_.code = ?
    AND a0_.activity = 1
  )
  AND a0_.panel IN ('a', 'ap')

SELECT a0_.activity AS activity_0, a0_.name AS name_1, a0_.synonym_rus AS synonym_rus_2, a0_.synonym_eng AS synonym_eng_3, a0_.description AS description_4, a0_.indications AS indications_5, a0_.popular AS popular_6, a0_.methods AS methods_7, a0_.bms AS bms_8, a0_.training AS training_9, a0_.id AS id_10, a0_.code AS code_11, a0_.lis_id AS lis_id_12, a1_.activity AS activity_13, a1_.name AS name_14, a1_.synonym_rus AS synonym_rus_15, a1_.synonym_eng AS synonym_eng_16, a1_.description AS description_17, a1_.indications AS indications_18, a1_.popular AS popular_19, a1_.methods AS methods_20, a1_.bms AS bms_21, a1_.training AS training_22, a1_.id AS id_23, a1_.code AS code_24, a1_.lis_id AS lis_id_25, i2_.price AS price_26, i2_.max_duration AS max_duration_27, i2_.duration_units AS duration_units_28, i2_.disallow_discount AS disallow_discount_29, i2_.id AS id_30, a3_.id AS id_31, i4_.name AS name_32, i4_.id AS id_33, i4_.code AS code_34, i4_.lis_id AS lis_id_35, a0_.panel AS panel_36, a0_.analysis_group_id AS analysis_group_id_37, a1_.panel AS panel_38, a1_.analysis_group_id AS analysis_group_id_39, i2_.analyse_id AS analyse_id_40, i2_.customer_id AS customer_id_41, a3_.type AS type_42, a3_.parent_id AS parent_id_43, a3_.biomaterial_id AS biomaterial_id_44, a3_.container_id AS container_id_45, a3_.analyse_id AS analyse_id_46, i4_.container_id AS container_id_47 FROM analyses a0_ LEFT JOIN analyses_analyses a5_ ON a0_.id = a5_.analyses_source LEFT JOIN analyses a1_ ON a1_.id = a5_.analyses_target AND a1_.panel IN ('a', 'ap') LEFT JOIN import_prices i2_ ON a0_.id = i2_.analyse_id AND (i2_.customer_id = 21) LEFT JOIN analyse_biomaterials a3_ ON a0_.id = a3_.parent_id AND a3_.type IN ('bm', 'pbm') LEFT JOIN import_biomaterials i4_ ON a3_.biomaterial_id = i4_.id WHERE (a0_.code = '50-107' AND a0_.activity = 1) AND a0_.panel IN ('a', 'ap');

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

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 = '/analyses/50-107' LIMIT 1;