| 1 |
0.31 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.84 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 = '14';
|
| 3 |
13.15 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.26 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 = '14';
|
| 5 |
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 = 15;
|
| 6 |
0.42 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 = 15;
|
| 7 |
0.26 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 = 42;
|
| 8 |
0.30 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 = 42;
|
| 9 |
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 = 71;
|
| 10 |
0.41 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 = 71;
|
| 11 |
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 = 76;
|
| 12 |
0.27 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 = 76;
|