Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.parent_id AS parent_id_3
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 57;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.city AS city_3,
  t0.postal_code AS postal_code_4,
  t0.business_id AS business_id_5
FROM
  adress t0
WHERE
  t0.business_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.business_id AS business_id_5 FROM adress t0 WHERE t0.business_id = 57;

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
  c0_.id AS id_0,
  COUNT(u1_.id) AS sclr_1
FROM
  company c2_
  INNER JOIN business b3_ ON c2_.id = b3_.id
  INNER JOIN `user` u1_ ON c2_.id = u1_.id
  INNER JOIN company_category c4_ ON c2_.id = c4_.company_id
  INNER JOIN category c0_ ON c0_.id = c4_.category_id
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, COUNT(u1_.id) AS sclr_1 FROM company c2_ INNER JOIN business b3_ ON c2_.id = b3_.id INNER JOIN `user` u1_ ON c2_.id = u1_.id INNER JOIN company_category c4_ ON c2_.id = c4_.company_id INNER JOIN category c0_ ON c0_.id = c4_.category_id GROUP BY c0_.id;

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,
          c2_.website AS website_13,
          c2_.foundation_year AS foundation_year_14,
          c2_.emp_num AS emp_num_15,
          u0_.type AS type_16
        FROM
          company c2_
          INNER JOIN business b1_ ON c2_.id = b1_.id
          INNER JOIN `user` u0_ ON c2_.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, c2_.website AS website_13, c2_.foundation_year AS foundation_year_14, c2_.emp_num AS emp_num_15, u0_.type AS type_16 FROM company c2_ INNER JOIN business b1_ ON c2_.id = b1_.id INNER JOIN `user` u0_ ON c2_.id = u0_.id ORDER BY u0_.id DESC) dctrn_result) dctrn_table;

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,
  c2_.website AS website_13,
  c2_.foundation_year AS foundation_year_14,
  c2_.emp_num AS emp_num_15,
  u0_.type AS type_16,
  u0_.personal_infos_id AS personal_infos_id_17,
  b1_.primary_contact_id AS primary_contact_id_18,
  b1_.entrepreneur_type_id AS entrepreneur_type_id_19
FROM
  company c2_
  INNER JOIN business b1_ ON c2_.id = b1_.id
  INNER JOIN `user` u0_ ON c2_.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, c2_.website AS website_13, c2_.foundation_year AS foundation_year_14, c2_.emp_num AS emp_num_15, u0_.type AS type_16, u0_.personal_infos_id AS personal_infos_id_17, b1_.primary_contact_id AS primary_contact_id_18, b1_.entrepreneur_type_id AS entrepreneur_type_id_19 FROM company c2_ INNER JOIN business b1_ ON c2_.id = b1_.id INNER JOIN `user` u0_ ON c2_.id = u0_.id WHERE u0_.id IN (57, 56, 55, 54, 53, 52) ORDER BY u0_.id DESC;

SELECT
  DISTINCT a0_.city AS city_0
FROM
  company c1_
  INNER JOIN business b2_ ON c1_.id = b2_.id
  INNER JOIN `user` u3_ ON c1_.id = u3_.id
  INNER JOIN adress a0_ ON b2_.id = a0_.business_id
WHERE
  a0_.city IS NOT NULL
ORDER BY
  a0_.city ASC

SELECT DISTINCT a0_.city AS city_0 FROM company c1_ INNER JOIN business b2_ ON c1_.id = b2_.id INNER JOIN `user` u3_ ON c1_.id = u3_.id INNER JOIN adress a0_ ON b2_.id = a0_.business_id WHERE a0_.city IS NOT NULL ORDER BY a0_.city ASC;

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,
          c2_.website AS website_13,
          c2_.foundation_year AS foundation_year_14,
          c2_.emp_num AS emp_num_15,
          u0_.type AS type_16
        FROM
          company c2_
          INNER JOIN business b1_ ON c2_.id = b1_.id
          INNER JOIN `user` u0_ ON c2_.id = u0_.id
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  6
OFFSET
  6

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, c2_.website AS website_13, c2_.foundation_year AS foundation_year_14, c2_.emp_num AS emp_num_15, u0_.type AS type_16 FROM company c2_ INNER JOIN business b1_ ON c2_.id = b1_.id INNER JOIN `user` u0_ ON c2_.id = u0_.id) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 6 OFFSET 6;

SELECT
  a0_.city AS city_0,
  COUNT(u1_.id) AS sclr_1
FROM
  company c2_
  INNER JOIN business b3_ ON c2_.id = b3_.id
  INNER JOIN `user` u1_ ON c2_.id = u1_.id
  INNER JOIN adress a0_ ON b3_.id = a0_.business_id
WHERE
  a0_.city IS NOT NULL
GROUP BY
  a0_.city

SELECT a0_.city AS city_0, COUNT(u1_.id) AS sclr_1 FROM company c2_ INNER JOIN business b3_ ON c2_.id = b3_.id INNER JOIN `user` u1_ ON c2_.id = u1_.id INNER JOIN adress a0_ ON b3_.id = a0_.business_id WHERE a0_.city IS NOT NULL GROUP BY a0_.city;