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 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"
  "sold"
  "archived"
]

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', 'sold', 'archived') GROUP BY a0_.id, a1_.id ORDER BY a0_.created_at DESC LIMIT 24;

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"
  "sold"
  "archived"
]

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', 'sold', 'archived');