| 1 |
0.55 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.97 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 = '15';
|
| 3 |
13.97 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.27 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 = '15';
|
| 5 |
0.71 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 = 38;
|
| 6 |
0.56 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 = 38;
|
| 7 |
0.47 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 = 43;
|
| 8 |
0.44 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 = 43;
|
| 9 |
0.33 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 = 62;
|
| 10 |
0.46 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 = 62;
|
| 11 |
0.32 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 = 64;
|
| 12 |
0.45 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 = 64;
|
| 13 |
0.30 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 = 75;
|
| 14 |
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 = 75;
|