Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.title AS title_2, t0.pricing_type AS pricing_type_3, t0.price_type AS price_type_4, t0.price AS price_5, t0.max_price AS max_price_6, t0.description AS description_7, t0.business_hours AS business_hours_8, t0.special_business_hours AS special_business_hours_9, t0.images AS images_10, t0.phone AS phone_11, t0.whatsapp_number AS whatsapp_number_12, t0.social_profiles AS social_profiles_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.expires_on AS expires_on_16, t0.slug AS slug_17, t0.views AS views_18, t0.phone_click_count AS phone_click_count_19, t0.phone_reveal_count AS phone_reveal_count_20, t0.avg_rating AS avg_rating_21, t0.deleted_at AS deleted_at_22, t0.category_id AS category_id_23, t0.artisan_id AS artisan_id_24, t0.ville_id AS ville_id_25, t0.region_id AS region_id_26, t0.status_id AS status_id_27 FROM artisan_post t0 WHERE t0.slug = ? LIMIT 1

[
  "sbagh"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.pricing_type AS pricing_type_3,
  t0.price_type AS price_type_4,
  t0.price AS price_5,
  t0.max_price AS max_price_6,
  t0.description AS description_7,
  t0.business_hours AS business_hours_8,
  t0.special_business_hours AS special_business_hours_9,
  t0.images AS images_10,
  t0.phone AS phone_11,
  t0.whatsapp_number AS whatsapp_number_12,
  t0.social_profiles AS social_profiles_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.expires_on AS expires_on_16,
  t0.slug AS slug_17,
  t0.views AS views_18,
  t0.phone_click_count AS phone_click_count_19,
  t0.phone_reveal_count AS phone_reveal_count_20,
  t0.avg_rating AS avg_rating_21,
  t0.deleted_at AS deleted_at_22,
  t0.category_id AS category_id_23,
  t0.artisan_id AS artisan_id_24,
  t0.ville_id AS ville_id_25,
  t0.region_id AS region_id_26,
  t0.status_id AS status_id_27
FROM
  artisan_post t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.pricing_type AS pricing_type_3, t0.price_type AS price_type_4, t0.price AS price_5, t0.max_price AS max_price_6, t0.description AS description_7, t0.business_hours AS business_hours_8, t0.special_business_hours AS special_business_hours_9, t0.images AS images_10, t0.phone AS phone_11, t0.whatsapp_number AS whatsapp_number_12, t0.social_profiles AS social_profiles_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.expires_on AS expires_on_16, t0.slug AS slug_17, t0.views AS views_18, t0.phone_click_count AS phone_click_count_19, t0.phone_reveal_count AS phone_reveal_count_20, t0.avg_rating AS avg_rating_21, t0.deleted_at AS deleted_at_22, t0.category_id AS category_id_23, t0.artisan_id AS artisan_id_24, t0.ville_id AS ville_id_25, t0.region_id AS region_id_26, t0.status_id AS status_id_27 FROM artisan_post t0 WHERE t0.slug = 'sbagh' LIMIT 1;

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 = ?

[
  "30"
  "fr"
  "App\Entity\ArtisanPost"
]

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 = '30' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\ArtisanPost';

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE artisan_post SET views = ? WHERE id = ?

[
  11
  30
]

UPDATE
  artisan_post
SET
  views = ?
WHERE
  id = ?

UPDATE artisan_post SET views = 11 WHERE id = 30;

"COMMIT"

[]

"COMMIT"

"COMMIT";

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 = ?

[
  101
]

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 = 101;

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 = ?

[
  "101"
  "fr"
  "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 t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = ?

[
  30
]

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.comment AS comment_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.status AS status_6,
  t0.user_id AS user_id_7,
  t0.artisan_post_id AS artisan_post_id_8
FROM
  review t0
WHERE
  t0.artisan_post_id = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.user_id AS user_id_7, t0.artisan_post_id AS artisan_post_id_8 FROM review t0 WHERE t0.artisan_post_id = 30;

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3 FROM ville t0 WHERE t0.id = ?

[
  22
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3
FROM
  ville t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3 FROM ville t0 WHERE t0.id = 22;

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 = ?

[
  "22"
  "fr"
  "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 = '22' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\Ville';

SELECT t0.id AS id_1, t0.name AS name_2 FROM tag t0 INNER JOIN artisan_post_tag ON t0.id = artisan_post_tag.tag_id WHERE artisan_post_tag.artisan_post_id = ?

[
  30
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  tag t0
  INNER JOIN artisan_post_tag ON t0.id = artisan_post_tag.tag_id
WHERE
  artisan_post_tag.artisan_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM tag t0 INNER JOIN artisan_post_tag ON t0.id = artisan_post_tag.tag_id WHERE artisan_post_tag.artisan_post_id = 30;

SELECT t0.id AS id_1, t0.name AS name_2 FROM feature t0 INNER JOIN feature_artisan_post ON t0.id = feature_artisan_post.feature_id WHERE feature_artisan_post.artisan_post_id = ?

[
  30
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  feature t0
  INNER JOIN feature_artisan_post ON t0.id = feature_artisan_post.feature_id
WHERE
  feature_artisan_post.artisan_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM feature t0 INNER JOIN feature_artisan_post ON t0.id = feature_artisan_post.feature_id WHERE feature_artisan_post.artisan_post_id = 30;

SELECT c0_.id AS id_0, c0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM artisan_post a1_ INNER JOIN category c0_ ON a1_.category_id = c0_.id GROUP BY c0_.id, c0_.name ORDER BY sclr_2 DESC LIMIT 5

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  COUNT(a1_.id) AS sclr_2
FROM
  artisan_post a1_
  INNER JOIN category c0_ ON a1_.category_id = c0_.id
GROUP BY
  c0_.id,
  c0_.name
ORDER BY
  sclr_2 DESC
LIMIT
  5

SELECT c0_.id AS id_0, c0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM artisan_post a1_ INNER JOIN category c0_ ON a1_.category_id = c0_.id GROUP BY c0_.id, c0_.name ORDER BY sclr_2 DESC LIMIT 5;