Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_6, t0.email AS email_7, t0.password AS password_8, t0.personal_infos_id AS personal_infos_id_9, t0.type, t2.company_name AS company_name_10, t2.trade_name AS trade_name_11, t2.licence_num AS licence_num_12, t2.company_num AS company_num_13, t2.logo AS logo_14, t2.banner AS banner_15, t2.phone_num AS phone_num_16, t2.about AS about_17, t2.why_choose_us AS why_choose_us_18, t2.services AS services_19, t2.primary_contact_id AS primary_contact_id_20, t2.entrepreneur_type_id AS entrepreneur_type_id_21, t4.city AS city_22, t4.exp_years AS exp_years_23, t4.category_id AS category_id_24, t5.website AS website_25, t5.foundation_year AS foundation_year_26, t5.emp_num AS emp_num_27 FROM `user` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN business t2 ON t0.id = t2.id LEFT JOIN individual t3 ON t0.id = t3.id LEFT JOIN professional t4 ON t0.id = t4.id LEFT JOIN company t5 ON t0.id = t5.id WHERE t0.id = ?

[
  60
]

SELECT
  t0.id AS id_6,
  t0.email AS email_7,
  t0.password AS password_8,
  t0.personal_infos_id AS personal_infos_id_9,
  t0.type,
  t2.company_name AS company_name_10,
  t2.trade_name AS trade_name_11,
  t2.licence_num AS licence_num_12,
  t2.company_num AS company_num_13,
  t2.logo AS logo_14,
  t2.banner AS banner_15,
  t2.phone_num AS phone_num_16,
  t2.about AS about_17,
  t2.why_choose_us AS why_choose_us_18,
  t2.services AS services_19,
  t2.primary_contact_id AS primary_contact_id_20,
  t2.entrepreneur_type_id AS entrepreneur_type_id_21,
  t4.city AS city_22,
  t4.exp_years AS exp_years_23,
  t4.category_id AS category_id_24,
  t5.website AS website_25,
  t5.foundation_year AS foundation_year_26,
  t5.emp_num AS emp_num_27
FROM
  `user` t0
  LEFT JOIN admin t1 ON t0.id = t1.id
  LEFT JOIN business t2 ON t0.id = t2.id
  LEFT JOIN individual t3 ON t0.id = t3.id
  LEFT JOIN professional t4 ON t0.id = t4.id
  LEFT JOIN company t5 ON t0.id = t5.id
WHERE
  t0.id = ?

SELECT t0.id AS id_6, t0.email AS email_7, t0.password AS password_8, t0.personal_infos_id AS personal_infos_id_9, t0.type, t2.company_name AS company_name_10, t2.trade_name AS trade_name_11, t2.licence_num AS licence_num_12, t2.company_num AS company_num_13, t2.logo AS logo_14, t2.banner AS banner_15, t2.phone_num AS phone_num_16, t2.about AS about_17, t2.why_choose_us AS why_choose_us_18, t2.services AS services_19, t2.primary_contact_id AS primary_contact_id_20, t2.entrepreneur_type_id AS entrepreneur_type_id_21, t4.city AS city_22, t4.exp_years AS exp_years_23, t4.category_id AS category_id_24, t5.website AS website_25, t5.foundation_year AS foundation_year_26, t5.emp_num AS emp_num_27 FROM `user` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN business t2 ON t0.id = t2.id LEFT JOIN individual t3 ON t0.id = t3.id LEFT JOIN professional t4 ON t0.id = t4.id LEFT JOIN company t5 ON t0.id = t5.id WHERE t0.id = 60;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.short_desc AS short_desc_3, b0_.description AS description_4, b0_.main_img AS main_img_5, b0_.multiple_imgs AS multiple_imgs_6, b0_.type AS type_7, b0_.created_at AS created_at_8 FROM blog b0_ WHERE b0_.type = ? ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table

[
  "Idea"
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.slug AS slug_2,
          b0_.short_desc AS short_desc_3,
          b0_.description AS description_4,
          b0_.main_img AS main_img_5,
          b0_.multiple_imgs AS multiple_imgs_6,
          b0_.type AS type_7,
          b0_.created_at AS created_at_8
        FROM
          blog b0_
        WHERE
          b0_.type = ?
        ORDER BY
          b0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.short_desc AS short_desc_3, b0_.description AS description_4, b0_.main_img AS main_img_5, b0_.multiple_imgs AS multiple_imgs_6, b0_.type AS type_7, b0_.created_at AS created_at_8 FROM blog b0_ WHERE b0_.type = 'Idea' ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table;

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_8 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.short_desc AS short_desc_3, b0_.description AS description_4, b0_.main_img AS main_img_5, b0_.multiple_imgs AS multiple_imgs_6, b0_.type AS type_7, b0_.created_at AS created_at_8 FROM blog b0_ WHERE b0_.type = ?) dctrn_result_inner ORDER BY created_at_8 DESC) dctrn_result LIMIT 6

[
  "Idea"
]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_8
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.slug AS slug_2,
          b0_.short_desc AS short_desc_3,
          b0_.description AS description_4,
          b0_.main_img AS main_img_5,
          b0_.multiple_imgs AS multiple_imgs_6,
          b0_.type AS type_7,
          b0_.created_at AS created_at_8
        FROM
          blog b0_
        WHERE
          b0_.type = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_8 DESC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_8 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.short_desc AS short_desc_3, b0_.description AS description_4, b0_.main_img AS main_img_5, b0_.multiple_imgs AS multiple_imgs_6, b0_.type AS type_7, b0_.created_at AS created_at_8 FROM blog b0_ WHERE b0_.type = 'Idea') dctrn_result_inner ORDER BY created_at_8 DESC) dctrn_result LIMIT 6;

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.short_desc AS short_desc_3, b0_.description AS description_4, b0_.main_img AS main_img_5, b0_.multiple_imgs AS multiple_imgs_6, b0_.type AS type_7, b0_.created_at AS created_at_8, b0_.category_id AS category_id_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.type = ? AND b0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY b0_.created_at DESC

[
  "Idea"
  41
  40
  37
  33
  30
  29
]

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.short_desc AS short_desc_3,
  b0_.description AS description_4,
  b0_.main_img AS main_img_5,
  b0_.multiple_imgs AS multiple_imgs_6,
  b0_.type AS type_7,
  b0_.created_at AS created_at_8,
  b0_.category_id AS category_id_9,
  b0_.author_id AS author_id_10
FROM
  blog b0_
WHERE
  b0_.type = ?
  AND b0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.short_desc AS short_desc_3, b0_.description AS description_4, b0_.main_img AS main_img_5, b0_.multiple_imgs AS multiple_imgs_6, b0_.type AS type_7, b0_.created_at AS created_at_8, b0_.category_id AS category_id_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.type = 'Idea' AND b0_.id IN (41, 40, 37, 33, 30, 29) ORDER BY b0_.created_at DESC;