Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          u0_.id AS id_0,
          u0_.email AS email_1,
          u0_.password AS password_2,
          b1_.company_name AS company_name_3,
          b1_.trade_name AS trade_name_4,
          b1_.licence_num AS licence_num_5,
          b1_.company_num AS company_num_6,
          b1_.logo AS logo_7,
          b1_.banner AS banner_8,
          b1_.phone_num AS phone_num_9,
          b1_.about AS about_10,
          b1_.why_choose_us AS why_choose_us_11,
          b1_.services AS services_12,
          p2_.city AS city_13,
          p2_.exp_years AS exp_years_14,
          u0_.type AS type_15
        FROM
          professional p2_
          INNER JOIN business b1_ ON p2_.id = b1_.id
          INNER JOIN `user` u0_ ON p2_.id = u0_.id
        ORDER BY
          u0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, p2_.city AS city_13, p2_.exp_years AS exp_years_14, u0_.type AS type_15 FROM professional p2_ INNER JOIN business b1_ ON p2_.id = b1_.id INNER JOIN `user` u0_ ON p2_.id = u0_.id ORDER BY u0_.id DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.parent_id AS parent_id_3
FROM
  category t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 ORDER BY t0.name ASC;

SELECT
  DISTINCT p0_.city AS city_0
FROM
  professional p0_
  INNER JOIN business b1_ ON p0_.id = b1_.id
  INNER JOIN `user` u2_ ON p0_.id = u2_.id
WHERE
  p0_.city IS NOT NULL
ORDER BY
  p0_.city ASC

SELECT DISTINCT p0_.city AS city_0 FROM professional p0_ INNER JOIN business b1_ ON p0_.id = b1_.id INNER JOIN `user` u2_ ON p0_.id = u2_.id WHERE p0_.city IS NOT NULL ORDER BY p0_.city ASC;

SELECT
  p0_.category_id AS sclr_0,
  COUNT(u1_.id) AS sclr_1
FROM
  professional p0_
  INNER JOIN business b2_ ON p0_.id = b2_.id
  INNER JOIN `user` u1_ ON p0_.id = u1_.id
GROUP BY
  p0_.category_id

SELECT p0_.category_id AS sclr_0, COUNT(u1_.id) AS sclr_1 FROM professional p0_ INNER JOIN business b2_ ON p0_.id = b2_.id INNER JOIN `user` u1_ ON p0_.id = u1_.id GROUP BY p0_.category_id;

SELECT
  p0_.city AS city_0,
  COUNT(u1_.id) AS sclr_1
FROM
  professional p0_
  INNER JOIN business b2_ ON p0_.id = b2_.id
  INNER JOIN `user` u1_ ON p0_.id = u1_.id
WHERE
  p0_.city IS NOT NULL
GROUP BY
  p0_.city

SELECT p0_.city AS city_0, COUNT(u1_.id) AS sclr_1 FROM professional p0_ INNER JOIN business b2_ ON p0_.id = b2_.id INNER JOIN `user` u1_ ON p0_.id = u1_.id WHERE p0_.city IS NOT NULL GROUP BY p0_.city;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          u0_.id AS id_0,
          u0_.email AS email_1,
          u0_.password AS password_2,
          b1_.company_name AS company_name_3,
          b1_.trade_name AS trade_name_4,
          b1_.licence_num AS licence_num_5,
          b1_.company_num AS company_num_6,
          b1_.logo AS logo_7,
          b1_.banner AS banner_8,
          b1_.phone_num AS phone_num_9,
          b1_.about AS about_10,
          b1_.why_choose_us AS why_choose_us_11,
          b1_.services AS services_12,
          p2_.city AS city_13,
          p2_.exp_years AS exp_years_14,
          u0_.type AS type_15
        FROM
          professional p2_
          INNER JOIN business b1_ ON p2_.id = b1_.id
          INNER JOIN `user` u0_ ON p2_.id = u0_.id
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  6
OFFSET
  18

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, p2_.city AS city_13, p2_.exp_years AS exp_years_14, u0_.type AS type_15 FROM professional p2_ INNER JOIN business b1_ ON p2_.id = b1_.id INNER JOIN `user` u0_ ON p2_.id = u0_.id) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 6 OFFSET 18;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  b1_.company_name AS company_name_3,
  b1_.trade_name AS trade_name_4,
  b1_.licence_num AS licence_num_5,
  b1_.company_num AS company_num_6,
  b1_.logo AS logo_7,
  b1_.banner AS banner_8,
  b1_.phone_num AS phone_num_9,
  b1_.about AS about_10,
  b1_.why_choose_us AS why_choose_us_11,
  b1_.services AS services_12,
  p2_.city AS city_13,
  p2_.exp_years AS exp_years_14,
  u0_.type AS type_15,
  u0_.personal_infos_id AS personal_infos_id_16,
  b1_.primary_contact_id AS primary_contact_id_17,
  b1_.entrepreneur_type_id AS entrepreneur_type_id_18,
  p2_.category_id AS category_id_19
FROM
  professional p2_
  INNER JOIN business b1_ ON p2_.id = b1_.id
  INNER JOIN `user` u0_ ON p2_.id = u0_.id
WHERE
  u0_.id IN (?, ?, ?)
ORDER BY
  u0_.id DESC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, b1_.company_name AS company_name_3, b1_.trade_name AS trade_name_4, b1_.licence_num AS licence_num_5, b1_.company_num AS company_num_6, b1_.logo AS logo_7, b1_.banner AS banner_8, b1_.phone_num AS phone_num_9, b1_.about AS about_10, b1_.why_choose_us AS why_choose_us_11, b1_.services AS services_12, p2_.city AS city_13, p2_.exp_years AS exp_years_14, u0_.type AS type_15, u0_.personal_infos_id AS personal_infos_id_16, b1_.primary_contact_id AS primary_contact_id_17, b1_.entrepreneur_type_id AS entrepreneur_type_id_18, p2_.category_id AS category_id_19 FROM professional p2_ INNER JOIN business b1_ ON p2_.id = b1_.id INNER JOIN `user` u0_ ON p2_.id = u0_.id WHERE u0_.id IN (4, 3, 2) ORDER BY u0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.phone AS phone_4,
  t0.email AS email_5
FROM
  primary_contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.phone AS phone_4,
  t0.email AS email_5
FROM
  primary_contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.phone AS phone_4,
  t0.email AS email_5
FROM
  primary_contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.email AS email_5 FROM primary_contact t0 WHERE t0.id = 1;