Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.custom_domain AS custom_domain_4, t0.theme AS theme_5, t0.theme_config AS theme_config_6, t0.is_active AS is_active_7, t0.analytics_scripts AS analytics_scripts_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.artisan_id AS artisan_id_11 FROM shop t0 WHERE t0.slug = ? LIMIT 1

[
  "la-poterie-de-cliousclat"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.custom_domain AS custom_domain_4,
  t0.theme AS theme_5,
  t0.theme_config AS theme_config_6,
  t0.is_active AS is_active_7,
  t0.analytics_scripts AS analytics_scripts_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.artisan_id AS artisan_id_11
FROM
  shop t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.custom_domain AS custom_domain_4, t0.theme AS theme_5, t0.theme_config AS theme_config_6, t0.is_active AS is_active_7, t0.analytics_scripts AS analytics_scripts_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.artisan_id AS artisan_id_11 FROM shop t0 WHERE t0.slug = 'la-poterie-de-cliousclat' LIMIT 1;

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM artwork a0_ LEFT JOIN artisan a1_ ON a0_.artisan_id = a1_.id WHERE a0_.status IN (?)

[
  "for_sale"
]

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  artwork a0_
  LEFT JOIN artisan a1_ ON a0_.artisan_id = a1_.id
WHERE
  a0_.status IN (?)

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM artwork a0_ LEFT JOIN artisan a1_ ON a0_.artisan_id = a1_.id WHERE a0_.status IN ('for_sale');

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.status AS status_4, a0_.price AS price_5, a0_.price_on_request AS price_on_request_6, a0_.year AS year_7, a0_.is_unique AS is_unique_8, a0_.edition_number AS edition_number_9, a0_.edition_total AS edition_total_10, a0_.height AS height_11, a0_.width AS width_12, a0_.depth AS depth_13, a0_.weight AS weight_14, a0_.shipping_weight AS shipping_weight_15, a0_.video_url AS video_url_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.published_at AS published_at_19, a0_.sold_at AS sold_at_20, a1_.id AS id_21, a1_.artist_name AS artist_name_22, a1_.slug AS slug_23, a1_.bio AS bio_24, a1_.profile_photo AS profile_photo_25, a1_.cover_photo AS cover_photo_26, a1_.city AS city_27, a1_.department AS department_28, a1_.region AS region_29, a1_.postal_code AS postal_code_30, a1_.country AS country_31, a1_.siret AS siret_32, a1_.cgv_filename AS cgv_filename_33, a1_.latitude AS latitude_34, a1_.longitude AS longitude_35, a1_.workshop_visitable AS workshop_visitable_36, a1_.workshop_hours AS workshop_hours_37, a1_.workshop_address AS workshop_address_38, a1_.website AS website_39, a1_.instagram AS instagram_40, a1_.facebook AS facebook_41, a1_.stripe_account_id AS stripe_account_id_42, a1_.stripe_onboarding_status AS stripe_onboarding_status_43, a1_.subscription_status AS subscription_status_44, a1_.subscription_stripe_id AS subscription_stripe_id_45, a1_.created_at AS created_at_46, a1_.updated_at AS updated_at_47, a0_.artisan_id AS artisan_id_48, a0_.category_id AS category_id_49, a1_.user_id AS user_id_50 FROM artwork a0_ LEFT JOIN artisan a1_ ON a0_.artisan_id = a1_.id WHERE a0_.status IN (?) GROUP BY a0_.id, a1_.id ORDER BY a0_.created_at DESC LIMIT 24

[
  "for_sale"
]

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.description AS description_3,
  a0_.status AS status_4,
  a0_.price AS price_5,
  a0_.price_on_request AS price_on_request_6,
  a0_.year AS year_7,
  a0_.is_unique AS is_unique_8,
  a0_.edition_number AS edition_number_9,
  a0_.edition_total AS edition_total_10,
  a0_.height AS height_11,
  a0_.width AS width_12,
  a0_.depth AS depth_13,
  a0_.weight AS weight_14,
  a0_.shipping_weight AS shipping_weight_15,
  a0_.video_url AS video_url_16,
  a0_.created_at AS created_at_17,
  a0_.updated_at AS updated_at_18,
  a0_.published_at AS published_at_19,
  a0_.sold_at AS sold_at_20,
  a1_.id AS id_21,
  a1_.artist_name AS artist_name_22,
  a1_.slug AS slug_23,
  a1_.bio AS bio_24,
  a1_.profile_photo AS profile_photo_25,
  a1_.cover_photo AS cover_photo_26,
  a1_.city AS city_27,
  a1_.department AS department_28,
  a1_.region AS region_29,
  a1_.postal_code AS postal_code_30,
  a1_.country AS country_31,
  a1_.siret AS siret_32,
  a1_.cgv_filename AS cgv_filename_33,
  a1_.latitude AS latitude_34,
  a1_.longitude AS longitude_35,
  a1_.workshop_visitable AS workshop_visitable_36,
  a1_.workshop_hours AS workshop_hours_37,
  a1_.workshop_address AS workshop_address_38,
  a1_.website AS website_39,
  a1_.instagram AS instagram_40,
  a1_.facebook AS facebook_41,
  a1_.stripe_account_id AS stripe_account_id_42,
  a1_.stripe_onboarding_status AS stripe_onboarding_status_43,
  a1_.subscription_status AS subscription_status_44,
  a1_.subscription_stripe_id AS subscription_stripe_id_45,
  a1_.created_at AS created_at_46,
  a1_.updated_at AS updated_at_47,
  a0_.artisan_id AS artisan_id_48,
  a0_.category_id AS category_id_49,
  a1_.user_id AS user_id_50
FROM
  artwork a0_
  LEFT JOIN artisan a1_ ON a0_.artisan_id = a1_.id
WHERE
  a0_.status IN (?)
GROUP BY
  a0_.id,
  a1_.id
ORDER BY
  a0_.created_at DESC
LIMIT
  24

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.status AS status_4, a0_.price AS price_5, a0_.price_on_request AS price_on_request_6, a0_.year AS year_7, a0_.is_unique AS is_unique_8, a0_.edition_number AS edition_number_9, a0_.edition_total AS edition_total_10, a0_.height AS height_11, a0_.width AS width_12, a0_.depth AS depth_13, a0_.weight AS weight_14, a0_.shipping_weight AS shipping_weight_15, a0_.video_url AS video_url_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.published_at AS published_at_19, a0_.sold_at AS sold_at_20, a1_.id AS id_21, a1_.artist_name AS artist_name_22, a1_.slug AS slug_23, a1_.bio AS bio_24, a1_.profile_photo AS profile_photo_25, a1_.cover_photo AS cover_photo_26, a1_.city AS city_27, a1_.department AS department_28, a1_.region AS region_29, a1_.postal_code AS postal_code_30, a1_.country AS country_31, a1_.siret AS siret_32, a1_.cgv_filename AS cgv_filename_33, a1_.latitude AS latitude_34, a1_.longitude AS longitude_35, a1_.workshop_visitable AS workshop_visitable_36, a1_.workshop_hours AS workshop_hours_37, a1_.workshop_address AS workshop_address_38, a1_.website AS website_39, a1_.instagram AS instagram_40, a1_.facebook AS facebook_41, a1_.stripe_account_id AS stripe_account_id_42, a1_.stripe_onboarding_status AS stripe_onboarding_status_43, a1_.subscription_status AS subscription_status_44, a1_.subscription_stripe_id AS subscription_stripe_id_45, a1_.created_at AS created_at_46, a1_.updated_at AS updated_at_47, a0_.artisan_id AS artisan_id_48, a0_.category_id AS category_id_49, a1_.user_id AS user_id_50 FROM artwork a0_ LEFT JOIN artisan a1_ ON a0_.artisan_id = a1_.id WHERE a0_.status IN ('for_sale') GROUP BY a0_.id, a1_.id ORDER BY a0_.created_at DESC LIMIT 24;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.icon AS icon_3, c0_.parent_id AS parent_id_4 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.icon AS icon_3,
  c0_.parent_id AS parent_id_4
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.icon AS icon_3, c0_.parent_id AS parent_id_4 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC;

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.description AS description_3 FROM technique t0_ ORDER BY t0_.name ASC LIMIT 20

[]

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.description AS description_3
FROM
  technique t0_
ORDER BY
  t0_.name ASC
LIMIT
  20

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.description AS description_3 FROM technique t0_ ORDER BY t0_.name ASC LIMIT 20;

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM material m0_ ORDER BY m0_.name ASC LIMIT 20

[]

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.slug AS slug_2
FROM
  material m0_
ORDER BY
  m0_.name ASC
LIMIT
  20

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM material m0_ ORDER BY m0_.name ASC LIMIT 20;