| 1 |
0.53 ms |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.active AS active_3 FROM media m0_
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.active AS active_3 FROM media m0_;
|
| 2 |
0.94 ms |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.is_video AS is_video_5, i0_.active AS active_6, i0_.image AS image_7 FROM item i0_ LEFT JOIN media_item m2_ ON i0_.id = m2_.item_id LEFT JOIN media m1_ ON m1_.id = m2_.media_id LEFT JOIN category_item c4_ ON i0_.id = c4_.item_id LEFT JOIN category c3_ ON c3_.id = c4_.category_id WHERE m1_.id = ? AND c3_.id = ?
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.is_video AS is_video_5, i0_.active AS active_6, i0_.image AS image_7 FROM item i0_ LEFT JOIN media_item m2_ ON i0_.id = m2_.item_id LEFT JOIN media m1_ ON m1_.id = m2_.media_id LEFT JOIN category_item c4_ ON i0_.id = c4_.item_id LEFT JOIN category c3_ ON c3_.id = c4_.category_id WHERE m1_.id = 3 AND c3_.id = '16';
|
| 3 |
13.11 ms |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.active AS active_5, i0_.is_video AS is_video_6, i0_.image AS image_7, SUM(v1_.vote) AS sclr_8 FROM item i0_ INNER JOIN vote v1_ ON i0_.id = v1_.item_id WHERE i0_.active = 1 GROUP BY i0_.id ORDER BY sclr_8 DESC LIMIT 9
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.attribute AS attribute_3, i0_.item_url AS item_url_4, i0_.active AS active_5, i0_.is_video AS is_video_6, i0_.image AS image_7, SUM(v1_.vote) AS sclr_8 FROM item i0_ INNER JOIN vote v1_ ON i0_.id = v1_.item_id WHERE i0_.active = 1 GROUP BY i0_.id ORDER BY sclr_8 DESC LIMIT 9;
|
| 4 |
0.25 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2 FROM category c0_ WHERE c0_.id = ?
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2 FROM category c0_ WHERE c0_.id = '16';
|
| 5 |
0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 47;
|
| 6 |
0.28 ms |
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 47;
|
| 7 |
0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 51;
|
| 8 |
0.25 ms |
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 51;
|
| 9 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 53;
|
| 10 |
0.26 ms |
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 53;
|
| 11 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 55;
|
| 12 |
0.22 ms |
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 55;
|
| 13 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 57;
|
| 14 |
0.28 ms |
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 57;
|
| 15 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 59;
|
| 16 |
0.38 ms |
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 59;
|
| 17 |
0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM category t0 INNER JOIN category_item ON t0.id = category_item.category_id WHERE category_item.item_id = 61;
|
| 18 |
0.28 ms |
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.item_id AS item_id_3 FROM vote t0 WHERE t0.item_id = 61;
|