Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.menu_order AS menu_order_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.status AS status_7,
  t0.icon AS icon_8,
  t0.parent_category_id AS parent_category_id_9
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.menu_order AS menu_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.icon AS icon_8, t0.parent_category_id AS parent_category_id_9 FROM category t0 WHERE t0.id = '100';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '100' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.pricing_type AS pricing_type_2,
  a0_.price_type AS price_type_3,
  a0_.price AS price_4,
  a0_.max_price AS max_price_5,
  a0_.description AS description_6,
  a0_.business_hours AS business_hours_7,
  a0_.special_business_hours AS special_business_hours_8,
  a0_.images AS images_9,
  a0_.phone AS phone_10,
  a0_.whatsapp_number AS whatsapp_number_11,
  a0_.social_profiles AS social_profiles_12,
  a0_.created_at AS created_at_13,
  a0_.updated_at AS updated_at_14,
  a0_.expires_on AS expires_on_15,
  a0_.slug AS slug_16,
  a0_.views AS views_17,
  a0_.phone_click_count AS phone_click_count_18,
  a0_.phone_reveal_count AS phone_reveal_count_19,
  a0_.avg_rating AS avg_rating_20,
  a0_.deleted_at AS deleted_at_21,
  c1_.id AS id_22,
  c1_.name AS name_23,
  c1_.description AS description_24,
  c1_.menu_order AS menu_order_25,
  c1_.created_at AS created_at_26,
  c1_.updated_at AS updated_at_27,
  c1_.status AS status_28,
  c1_.icon AS icon_29,
  v2_.id AS id_30,
  v2_.name AS name_31,
  v2_.postal_code AS postal_code_32,
  a0_.category_id AS category_id_33,
  a0_.artisan_id AS artisan_id_34,
  a0_.ville_id AS ville_id_35,
  a0_.region_id AS region_id_36,
  a0_.status_id AS status_id_37,
  c1_.parent_category_id AS parent_category_id_38
FROM
  artisan_post a0_
  LEFT JOIN category c1_ ON a0_.category_id = c1_.id
  LEFT JOIN ville v2_ ON a0_.ville_id = v2_.id
  LEFT JOIN review r3_ ON a0_.id = r3_.artisan_post_id
WHERE
  a0_.deleted_at IS NULL
  AND a0_.category_id = ?
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.pricing_type AS pricing_type_2, a0_.price_type AS price_type_3, a0_.price AS price_4, a0_.max_price AS max_price_5, a0_.description AS description_6, a0_.business_hours AS business_hours_7, a0_.special_business_hours AS special_business_hours_8, a0_.images AS images_9, a0_.phone AS phone_10, a0_.whatsapp_number AS whatsapp_number_11, a0_.social_profiles AS social_profiles_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.expires_on AS expires_on_15, a0_.slug AS slug_16, a0_.views AS views_17, a0_.phone_click_count AS phone_click_count_18, a0_.phone_reveal_count AS phone_reveal_count_19, a0_.avg_rating AS avg_rating_20, a0_.deleted_at AS deleted_at_21, c1_.id AS id_22, c1_.name AS name_23, c1_.description AS description_24, c1_.menu_order AS menu_order_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, c1_.status AS status_28, c1_.icon AS icon_29, v2_.id AS id_30, v2_.name AS name_31, v2_.postal_code AS postal_code_32, a0_.category_id AS category_id_33, a0_.artisan_id AS artisan_id_34, a0_.ville_id AS ville_id_35, a0_.region_id AS region_id_36, a0_.status_id AS status_id_37, c1_.parent_category_id AS parent_category_id_38 FROM artisan_post a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id LEFT JOIN ville v2_ ON a0_.ville_id = v2_.id LEFT JOIN review r3_ ON a0_.id = r3_.artisan_post_id WHERE a0_.deleted_at IS NULL AND a0_.category_id = 100 ORDER BY a0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.menu_order AS menu_order_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.status AS status_7,
  t0.icon AS icon_8,
  t0.parent_category_id AS parent_category_id_9
FROM
  category t0
ORDER BY
  t0.menu_order ASC
LIMIT
  10

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.menu_order AS menu_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.icon AS icon_8, t0.parent_category_id AS parent_category_id_9 FROM category t0 ORDER BY t0.menu_order ASC LIMIT 10;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '14' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '88' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '79' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '130' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '127' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '101' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '94' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '77' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '86' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3
FROM
  ville t0
ORDER BY
  t0.id ASC
LIMIT
  10

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3 FROM ville t0 ORDER BY t0.id ASC LIMIT 10;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '5' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '6' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '7' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '8' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '9' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '10' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '11' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '12' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.menu_order AS menu_order_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.status AS status_6,
  c0_.icon AS icon_7,
  c0_.parent_category_id AS parent_category_id_8
FROM
  category c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.menu_order AS menu_order_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.status AS status_6, c0_.icon AS icon_7, c0_.parent_category_id AS parent_category_id_8 FROM category c0_;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '78' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Category';