| 1 |
4.37 ms |
SELECT e0_.email AS email_0, e0_.phone AS phone_1, e0_.site AS site_2, e0_.updated AS updated_3, e0_.center AS center_4, e0_.created AS created_5, e0_.description AS description_6, e0_.id AS id_7, e0_.slug AS slug_8, e0_.status AS status_9, e0_.title AS title_10, e0_.visible AS visible_11, e0_.address_id AS address_id_12, e0_.partner_id AS partner_id_13, e0_.picture_id AS picture_id_14, e0_.user_id AS user_id_15 FROM event e0_ INNER JOIN date d1_ ON e0_.id = d1_.event_id LEFT JOIN address a2_ ON e0_.address_id = a2_.id LEFT JOIN event_category e4_ ON e0_.id = e4_.event_id LEFT JOIN category c3_ ON c3_.id = e4_.category_id LEFT JOIN event_talent e6_ ON e0_.id = e6_.event_id LEFT JOIN talent t5_ ON t5_.id = e6_.talent_id WHERE e0_.status = ? AND e0_.visible = ? AND e0_.slug = ?
Parameters: [
"valid"
1
"retrouvez-nous-a-la-foire-expo"
]
SELECT e0_.email AS email_0, e0_.phone AS phone_1, e0_.site AS site_2, e0_.updated AS updated_3, e0_.center AS center_4, e0_.created AS created_5, e0_.description AS description_6, e0_.id AS id_7, e0_.slug AS slug_8, e0_.status AS status_9, e0_.title AS title_10, e0_.visible AS visible_11, e0_.address_id AS address_id_12, e0_.partner_id AS partner_id_13, e0_.picture_id AS picture_id_14, e0_.user_id AS user_id_15 FROM event e0_ INNER JOIN date d1_ ON e0_.id = d1_.event_id LEFT JOIN address a2_ ON e0_.address_id = a2_.id LEFT JOIN event_category e4_ ON e0_.id = e4_.event_id LEFT JOIN category c3_ ON c3_.id = e4_.category_id LEFT JOIN event_talent e6_ ON e0_.id = e6_.event_id LEFT JOIN talent t5_ ON t5_.id = e6_.talent_id WHERE e0_.status = 'valid' AND e0_.visible = 1 AND e0_.slug = 'retrouvez-nous-a-la-foire-expo';
|
| 2 |
0.89 ms |
SELECT e0_.email AS email_0, e0_.phone AS phone_1, e0_.site AS site_2, e0_.updated AS updated_3, e0_.center AS center_4, e0_.created AS created_5, e0_.description AS description_6, e0_.id AS id_7, e0_.slug AS slug_8, e0_.status AS status_9, e0_.title AS title_10, e0_.visible AS visible_11, e0_.address_id AS address_id_12, e0_.partner_id AS partner_id_13, e0_.picture_id AS picture_id_14, e0_.user_id AS user_id_15 FROM event e0_ INNER JOIN date d1_ ON e0_.id = d1_.event_id LEFT JOIN address a2_ ON e0_.address_id = a2_.id LEFT JOIN event_category e4_ ON e0_.id = e4_.event_id LEFT JOIN category c3_ ON c3_.id = e4_.category_id LEFT JOIN event_talent e6_ ON e0_.id = e6_.event_id LEFT JOIN talent t5_ ON t5_.id = e6_.talent_id WHERE e0_.status = ? AND e0_.visible = ? AND e0_.id <> ? ORDER BY d1_.start ASC LIMIT 10
Parameters: [
"valid"
1
2756
]
SELECT e0_.email AS email_0, e0_.phone AS phone_1, e0_.site AS site_2, e0_.updated AS updated_3, e0_.center AS center_4, e0_.created AS created_5, e0_.description AS description_6, e0_.id AS id_7, e0_.slug AS slug_8, e0_.status AS status_9, e0_.title AS title_10, e0_.visible AS visible_11, e0_.address_id AS address_id_12, e0_.partner_id AS partner_id_13, e0_.picture_id AS picture_id_14, e0_.user_id AS user_id_15 FROM event e0_ INNER JOIN date d1_ ON e0_.id = d1_.event_id LEFT JOIN address a2_ ON e0_.address_id = a2_.id LEFT JOIN event_category e4_ ON e0_.id = e4_.event_id LEFT JOIN category c3_ ON c3_.id = e4_.category_id LEFT JOIN event_talent e6_ ON e0_.id = e6_.event_id LEFT JOIN talent t5_ ON t5_.id = e6_.talent_id WHERE e0_.status = 'valid' AND e0_.visible = 1 AND e0_.id <> 2756 ORDER BY d1_.start ASC LIMIT 10;
|
| 3 |
0.67 ms |
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_.event_id = ?
Parameters: [
"2026-06-04 21:21:53"
"216.73.216.142"
0
2756
]
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-06-04 21:21:53' AND v0_.ip = '216.73.216.142' AND v0_.preview = 0 AND v0_.event_id = 2756;
|
| 4 |
0.17 ms |
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = 2756 ORDER BY t0.start ASC;
|
| 5 |
0.11 ms |
SELECT t0.place AS place_1, t0.updated AS updated_2, t0.city AS city_3, t0.created AS created_4, t0.id AS id_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.postal AS postal_8, t0.street AS street_9 FROM address t0 WHERE t0.id = ?
SELECT t0.place AS place_1, t0.updated AS updated_2, t0.city AS city_3, t0.created AS created_4, t0.id AS id_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.postal AS postal_8, t0.street AS street_9 FROM address t0 WHERE t0.id = 2874;
|
| 6 |
0.17 ms |
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 = 10055;
|
| 7 |
0.20 ms |
SELECT t0.ip AS ip_1, t0.created AS created_2, t0.env AS env_3, t0.id AS id_4, t0.preview AS preview_5, t0.article_id AS article_id_6, t0.event_id AS event_id_7, t0.partner_id AS partner_id_8, t0.talent_id AS talent_id_9, t0.user_id AS user_id_10 FROM view t0 WHERE t0.event_id = ?
SELECT t0.ip AS ip_1, t0.created AS created_2, t0.env AS env_3, t0.id AS id_4, t0.preview AS preview_5, t0.article_id AS article_id_6, t0.event_id AS event_id_7, t0.partner_id AS partner_id_8, t0.talent_id AS talent_id_9, t0.user_id AS user_id_10 FROM view t0 WHERE t0.event_id = 2756;
|
| 8 |
0.20 ms |
SELECT t0.created AS created_1, t0.env AS env_2, t0.id AS id_3, t0.article_id AS article_id_4, t0.event_id AS event_id_5, t0.partner_id AS partner_id_6, t0.publication_id AS publication_id_7, t0.talent_id AS talent_id_8, t0.user_id AS user_id_9 FROM `like` t0 WHERE t0.event_id = ?
SELECT t0.created AS created_1, t0.env AS env_2, t0.id AS id_3, t0.article_id AS article_id_4, t0.event_id AS event_id_5, t0.partner_id AS partner_id_6, t0.publication_id AS publication_id_7, t0.talent_id AS talent_id_8, t0.user_id AS user_id_9 FROM `like` t0 WHERE t0.event_id = 2756;
|
| 9 |
0.29 ms |
SELECT t0_.email AS email_0, t0_.phone AS phone_1, t0_.site AS site_2, t0_.updated AS updated_3, t0_.created AS created_4, t0_.description AS description_5, t0_.id AS id_6, t0_.name AS name_7, t0_.slug AS slug_8, t0_.visible AS visible_9, t0_.picture_id AS picture_id_10 FROM talent t0_ LEFT JOIN event_talent e2_ ON t0_.id = e2_.talent_id LEFT JOIN event e1_ ON e1_.id = e2_.event_id LEFT JOIN view v3_ ON t0_.id = v3_.talent_id LEFT JOIN `like` l4_ ON t0_.id = l4_.talent_id WHERE t0_.visible = ? AND e1_.id = ? GROUP BY t0_.id ORDER BY COUNT(l4_.id) DESC, COUNT(v3_.id) DESC
SELECT t0_.email AS email_0, t0_.phone AS phone_1, t0_.site AS site_2, t0_.updated AS updated_3, t0_.created AS created_4, t0_.description AS description_5, t0_.id AS id_6, t0_.name AS name_7, t0_.slug AS slug_8, t0_.visible AS visible_9, t0_.picture_id AS picture_id_10 FROM talent t0_ LEFT JOIN event_talent e2_ ON t0_.id = e2_.talent_id LEFT JOIN event e1_ ON e1_.id = e2_.event_id LEFT JOIN view v3_ ON t0_.id = v3_.talent_id LEFT JOIN `like` l4_ ON t0_.id = l4_.talent_id WHERE t0_.visible = 1 AND e1_.id = 2756 GROUP BY t0_.id ORDER BY COUNT(l4_.id) DESC, COUNT(v3_.id) DESC;
|
| 10 |
0.28 ms |
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_.event_id = ?
Parameters: [
"2026-06-04 21:21:53"
"216.73.216.142"
1
2776
]
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-06-04 21:21:53' AND v0_.ip = '216.73.216.142' AND v0_.preview = 1 AND v0_.event_id = 2776;
|
| 11 |
0.21 ms |
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_.event_id = ?
Parameters: [
"2026-06-04 21:21:53"
"216.73.216.142"
1
2767
]
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-06-04 21:21:53' AND v0_.ip = '216.73.216.142' AND v0_.preview = 1 AND v0_.event_id = 2767;
|
| 12 |
1.08 ms |
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_.event_id = ?
Parameters: [
"2026-06-04 21:21:53"
"216.73.216.142"
1
2598
]
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-06-04 21:21:53' AND v0_.ip = '216.73.216.142' AND v0_.preview = 1 AND v0_.event_id = 2598;
|
| 13 |
0.12 ms |
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = 2776 ORDER BY t0.start ASC;
|
| 14 |
0.10 ms |
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 = 10109;
|
| 15 |
0.11 ms |
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = 2767 ORDER BY t0.start ASC;
|
| 16 |
0.09 ms |
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 = 10097;
|
| 17 |
0.13 ms |
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC
SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = 2598 ORDER BY t0.start ASC;
|
| 18 |
0.10 ms |
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 = 9319;
|