96.56 ms (55.74%)
|
1 |
SELECT p0_.date AS date_0, p0_.email AS email_1, p0_.phone AS phone_2, p0_.site AS site_3, p0_.updated AS updated_4, p0_.center AS center_5, p0_.close AS close_6, p0_.created AS created_7, p0_.description AS description_8, p0_.id AS id_9, p0_.name AS name_10, p0_.slug AS slug_11, p0_.title AS title_12, p0_.visible AS visible_13, p0_.address_id AS address_id_14, p0_.pdf_id AS pdf_id_15, p0_.picture_id AS picture_id_16 FROM partner p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id LEFT JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN view v4_ ON p0_.id = v4_.partner_id LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id WHERE p0_.visible = ? AND c2_.slug = ? GROUP BY p0_.id ORDER BY COUNT(l5_.id) DESC, COUNT(v4_.id) DESC
Parameters: [
1
"artisans-locaux"
]
SELECT p0_.date AS date_0, p0_.email AS email_1, p0_.phone AS phone_2, p0_.site AS site_3, p0_.updated AS updated_4, p0_.center AS center_5, p0_.close AS close_6, p0_.created AS created_7, p0_.description AS description_8, p0_.id AS id_9, p0_.name AS name_10, p0_.slug AS slug_11, p0_.title AS title_12, p0_.visible AS visible_13, p0_.address_id AS address_id_14, p0_.pdf_id AS pdf_id_15, p0_.picture_id AS picture_id_16 FROM partner p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id LEFT JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN view v4_ ON p0_.id = v4_.partner_id LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id WHERE p0_.visible = 1 AND c2_.slug = 'artisans-locaux' GROUP BY p0_.id ORDER BY COUNT(l5_.id) DESC, COUNT(v4_.id) DESC;
|
69.86 ms (40.32%)
|
17 |
SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= ? AND v0_.ip = ? AND v0_.preview = ? AND v0_.partner_id = ?
Parameters: [
"2026-04-17 08:03:25"
"216.73.217.139"
1
109
]
SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= '2026-04-17 08:03:25' AND v0_.ip = '216.73.217.139' AND v0_.preview = 1 AND v0_.partner_id = 109;
|
2.60 ms (1.50%)
|
17 |
SELECT t0.break AS break_1, t0.resume AS resume_2, t0.updated AS updated_3, t0.close AS close_4, t0.created AS created_5, t0.day AS day_6, t0.id AS id_7, t0.open AS open_8, t0.partner_id AS partner_id_9 FROM schedule t0 WHERE t0.partner_id = ?
SELECT t0.break AS break_1, t0.resume AS resume_2, t0.updated AS updated_3, t0.close AS close_4, t0.created AS created_5, t0.day AS day_6, t0.id AS id_7, t0.open AS open_8, t0.partner_id AS partner_id_9 FROM schedule t0 WHERE t0.partner_id = 109;
|
2.38 ms (1.37%)
|
17 |
SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = ?
SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = 970;
|
1.18 ms (0.68%)
|
7 |
INSERT INTO view (ip, created, env, preview, article_id, event_id, partner_id, talent_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"216.73.217.139"
"2026-04-18 08:03:25"
"site"
1
null
null
231
null
null
]
INSERT INTO view (ip, created, env, preview, article_id, event_id, partner_id, talent_id, user_id) VALUES ('216.73.217.139', '2026-04-18 08:03:25', 'site', 1, NULL, NULL, 231, NULL, NULL);
|
0.41 ms (0.24%)
|
1 |
SELECT c0_.updated AS updated_0, c0_.created AS created_1, c0_.entities AS entities_2, c0_.id AS id_3, c0_.major AS major_4, c0_.slug AS slug_5, c0_.title AS title_6 FROM category c0_ WHERE c0_.entities LIKE ? ORDER BY c0_.title ASC
Parameters: [
"%partner%"
]
SELECT c0_.updated AS updated_0, c0_.created AS created_1, c0_.entities AS entities_2, c0_.id AS id_3, c0_.major AS major_4, c0_.slug AS slug_5, c0_.title AS title_6 FROM category c0_ WHERE c0_.entities LIKE '%partner%' ORDER BY c0_.title ASC;
|
0.17 ms (0.10%)
|
1 |
"COMMIT"
|
0.08 ms (0.04%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|