Symfony Profiler

Query Metrics

95 Database Queries

8 Different statements

52.40 ms Query time

0 Invalid entities

Queries


SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = ?
SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = ? ORDER BY c0_.title ASC LIMIT 1
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0
SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0 ORDER BY p0_.title ASC LIMIT 20 OFFSET 340
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.product_key AS product_key_4, p0_.price_pdv AS price_pdv_5, p0_.price AS price_6, p0_.vat AS vat_7, p0_.is_out_of_stock AS is_out_of_stock_8, p0_.is_new AS is_new_9, p0_.is_discount AS is_discount_10, p0_.is_super_product AS is_super_product_11, p0_.is_outlet AS is_outlet_12, p0_.is_suspended AS is_suspended_13, c1_.title AS title_14, i2_.thumbnail_100x100 AS thumbnail_100x100_15, i2_.thumbnail_500x500 AS thumbnail_500x500_16 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.title ASC
SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = ? ORDER BY c0_.title ASC
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0
SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?
SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ?

#▲	Time	Info
1	2.07 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = ? Parameters: [`"1434"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = '1434';
2	1.50 ms	SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = ? ORDER BY c0_.title ASC LIMIT 1 Parameters: [`1434`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = ? ORDER BY c0_.title ASC LIMIT 1 SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = 1434 ORDER BY c0_.title ASC LIMIT 1;
3	0.52 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1434`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1434 AND c0_.is_suspended = 0;
4	0.34 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1436`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1436 AND c0_.is_suspended = 0;
5	0.33 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1437`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1437 AND c0_.is_suspended = 0;
6	0.30 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1438`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1438 AND c0_.is_suspended = 0;
7	0.29 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1439`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1439 AND c0_.is_suspended = 0;
8	0.24 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1440`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1440 AND c0_.is_suspended = 0;
9	0.28 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1441`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1441 AND c0_.is_suspended = 0;
10	0.28 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1442`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1442 AND c0_.is_suspended = 0;
11	0.30 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1443`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1443 AND c0_.is_suspended = 0;
12	0.26 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1497`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1497 AND c0_.is_suspended = 0;
13	0.28 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1444`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1444 AND c0_.is_suspended = 0;
14	0.30 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1445`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1445 AND c0_.is_suspended = 0;
15	0.27 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1446`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1446 AND c0_.is_suspended = 0;
16	0.26 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1447`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1447 AND c0_.is_suspended = 0;
17	0.23 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1448`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1448 AND c0_.is_suspended = 0;
18	0.26 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1449`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1449 AND c0_.is_suspended = 0;
19	0.28 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1450`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1450 AND c0_.is_suspended = 0;
20	0.25 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1451`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1451 AND c0_.is_suspended = 0;
21	0.27 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1452`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1452 AND c0_.is_suspended = 0;
22	0.23 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1453`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1453 AND c0_.is_suspended = 0;
23	0.29 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1454`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1454 AND c0_.is_suspended = 0;
24	0.24 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1455`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1455 AND c0_.is_suspended = 0;
25	0.24 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1456`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1456 AND c0_.is_suspended = 0;
26	0.29 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1457`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1457 AND c0_.is_suspended = 0;
27	7.08 ms	SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0 Parameters: [`1434 1436 1437 1438 1439 1440 1441 1442 1443 1497 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457`] View formatted query View runnable query Explain query SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND p0_.price_pdv > 0 SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (1434, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1497, 1444, 1445, 1446, 1447, 1448, 1449, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457) AND p0_.price_pdv > 0;
28	5.96 ms	SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0 ORDER BY p0_.title ASC LIMIT 20 OFFSET 340 Parameters: [`1434 1436 1437 1438 1439 1440 1441 1442 1443 1497 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457`] View formatted query View runnable query Explain query SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND p0_.price_pdv > 0 ORDER BY p0_.title ASC LIMIT 20 OFFSET 340 SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (1434, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1497, 1444, 1445, 1446, 1447, 1448, 1449, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457) AND p0_.price_pdv > 0 ORDER BY p0_.title ASC LIMIT 20 OFFSET 340;
29	1.08 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.product_key AS product_key_4, p0_.price_pdv AS price_pdv_5, p0_.price AS price_6, p0_.vat AS vat_7, p0_.is_out_of_stock AS is_out_of_stock_8, p0_.is_new AS is_new_9, p0_.is_discount AS is_discount_10, p0_.is_super_product AS is_super_product_11, p0_.is_outlet AS is_outlet_12, p0_.is_suspended AS is_suspended_13, c1_.title AS title_14, i2_.thumbnail_100x100 AS thumbnail_100x100_15, i2_.thumbnail_500x500 AS thumbnail_500x500_16 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.price_pdv > 0 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.title ASC Parameters: [`1434 1436 1437 1438 1439 1440 1441 1442 1443 1497 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 21076 21077 21079 21080 21078 21081 21082 21083 27165 17767 16163 19022 17768 17769 17770 17771 17772 17773 28766 462`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.product_key AS product_key_4, p0_.price_pdv AS price_pdv_5, p0_.price AS price_6, p0_.vat AS vat_7, p0_.is_out_of_stock AS is_out_of_stock_8, p0_.is_new AS is_new_9, p0_.is_discount AS is_discount_10, p0_.is_super_product AS is_super_product_11, p0_.is_outlet AS is_outlet_12, p0_.is_suspended AS is_suspended_13, c1_.title AS title_14, i2_.thumbnail_100x100 AS thumbnail_100x100_15, i2_.thumbnail_500x500 AS thumbnail_500x500_16 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND p0_.price_pdv > 0 AND p0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY p0_.title ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.product_key AS product_key_4, p0_.price_pdv AS price_pdv_5, p0_.price AS price_6, p0_.vat AS vat_7, p0_.is_out_of_stock AS is_out_of_stock_8, p0_.is_new AS is_new_9, p0_.is_discount AS is_discount_10, p0_.is_super_product AS is_super_product_11, p0_.is_outlet AS is_outlet_12, p0_.is_suspended AS is_suspended_13, c1_.title AS title_14, i2_.thumbnail_100x100 AS thumbnail_100x100_15, i2_.thumbnail_500x500 AS thumbnail_500x500_16 FROM product p0_ LEFT JOIN categories c1_ ON p0_.category_id = c1_.id LEFT JOIN images i2_ ON p0_.main_image_id = i2_.id WHERE p0_.category_id IN (1434, 1436, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1497, 1444, 1445, 1446, 1447, 1448, 1449, 1450, 1451, 1452, 1453, 1454, 1455, 1456, 1457) AND p0_.price_pdv > 0 AND p0_.id IN (21076, 21077, 21079, 21080, 21078, 21081, 21082, 21083, 27165, 17767, 16163, 19022, 17768, 17769, 17770, 17771, 17772, 17773, 28766, 462) ORDER BY p0_.title ASC;
30	0.66 ms	SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = ? ORDER BY c0_.title ASC Parameters: [`1434`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = ? ORDER BY c0_.title ASC SELECT c0_.id AS id_0, c0_.title AS title_1 FROM categories c0_ WHERE c0_.is_suspended = 0 AND c0_.parent_id = 1434 ORDER BY c0_.title ASC;
31	0.47 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1434`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1434 AND c0_.is_suspended = 0;
32	0.43 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1436`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1436 AND c0_.is_suspended = 0;
33	0.31 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1437`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1437 AND c0_.is_suspended = 0;
34	0.26 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1438`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1438 AND c0_.is_suspended = 0;
35	0.31 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1439`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1439 AND c0_.is_suspended = 0;
36	0.32 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1440`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1440 AND c0_.is_suspended = 0;
37	0.30 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1441`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1441 AND c0_.is_suspended = 0;
38	0.26 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1442`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1442 AND c0_.is_suspended = 0;
39	0.26 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1443`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1443 AND c0_.is_suspended = 0;
40	0.27 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1497`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1497 AND c0_.is_suspended = 0;
41	0.26 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1444`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1444 AND c0_.is_suspended = 0;
42	0.27 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1445`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1445 AND c0_.is_suspended = 0;
43	0.25 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1446`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1446 AND c0_.is_suspended = 0;
44	0.28 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1447`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1447 AND c0_.is_suspended = 0;
45	0.31 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1448`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1448 AND c0_.is_suspended = 0;
46	0.29 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1449`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1449 AND c0_.is_suspended = 0;
47	0.30 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1450`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1450 AND c0_.is_suspended = 0;
48	0.26 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1451`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1451 AND c0_.is_suspended = 0;
49	0.29 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1452`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1452 AND c0_.is_suspended = 0;
50	0.32 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1453`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1453 AND c0_.is_suspended = 0;
51	0.25 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1454`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1454 AND c0_.is_suspended = 0;
52	0.24 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1455`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1455 AND c0_.is_suspended = 0;
53	0.29 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1456`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1456 AND c0_.is_suspended = 0;
54	0.24 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 Parameters: [`1457`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = ? AND c0_.is_suspended = 0 SELECT c0_.id AS id_0, c0_.title AS title_1, c1_.id AS id_2 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id WHERE c0_.parent_id = 1457 AND c0_.is_suspended = 0;
55	4.05 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = ? Parameters: [`1303`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.title3 AS title3_4, t0.is_suspended AS is_suspended_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.created AS created_10, t0.updated AS updated_11, t0.edit_by_id AS edit_by_id_12, t0.parent_id AS parent_id_13, t0.choice_id AS choice_id_14 FROM categories t0 WHERE t0.id = 1303;
56	0.76 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21076`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21076;
57	5.19 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21076`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21076;
58	0.42 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21077`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21077;
59	0.32 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21077`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21077;
60	0.30 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21079`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21079;
61	0.30 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21079`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21079;
62	0.33 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21080`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21080;
63	0.26 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21080`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21080;
64	0.28 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21078`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21078;
65	0.24 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21078`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21078;
66	0.27 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21081`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21081;
67	0.28 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21081`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21081;
68	0.28 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21082`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21082;
69	0.27 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21082`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21082;
70	0.27 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21083`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21083;
71	0.26 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 21083`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 21083;
72	0.25 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 27165`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 27165;
73	0.24 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 27165`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 27165;
74	0.25 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17767`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17767;
75	0.24 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17767`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17767;
76	0.26 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 16163`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 16163;
77	0.25 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 16163`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 16163;
78	0.26 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 19022`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 19022;
79	0.24 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 19022`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 19022;
80	0.24 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17768`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17768;
81	0.23 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17768`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17768;
82	0.26 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17769`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17769;
83	0.24 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17769`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17769;
84	0.25 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17770`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17770;
85	0.25 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17770`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17770;
86	0.26 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17771`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17771;
87	0.24 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17771`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17771;
88	0.25 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17772`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17772;
89	0.35 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17772`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17772;
90	0.26 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17773`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17773;
91	0.24 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 17773`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 17773;
92	0.26 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 28766`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 28766;
93	0.23 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 28766`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 28766;
94	0.25 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 462`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 462;
95	0.26 ms	SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? Parameters: [`1 462`] View formatted query View runnable query Explain query SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = ? AND c0_.ocena IS NOT NULL AND c0_.product_id = ? SELECT AVG(c0_.ocena) AS sclr_0 FROM comments c0_ WHERE c0_.status = 1 AND c0_.ocena IS NOT NULL AND c0_.product_id = 462;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\User	No errors.
App\Entity\Choice	No errors.
App\Entity\Product	No errors.
App\Entity\Image	No errors.
App\Entity\Comment	No errors.

Symfony Profiler

GET https://pcboomboom.rs/shop/list/1434?direction=desc&page=18

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping