3.17 ms (36.48%)
1
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC LIMIT 6
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC LIMIT 6 ;
Copy
2.15 ms (24.73%)
1
SELECT id , name , parent_id FROM goods . category
SELECT id , name , parent_id FROM goods . category ;
Copy
1.57 ms (18.07%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . price AS price_3 , t0 . description AS description_4 , t0 . is_archive AS is_archive_5 , t0 . date_add AS date_add_6 , t0 . end_date AS end_date_7 , t0 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = ? ORDER BY t0 . date_add DESC LIMIT 4
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . price AS price_3 , t0 . description AS description_4 , t0 . is_archive AS is_archive_5 , t0 . date_add AS date_add_6 , t0 . end_date AS end_date_7 , t0 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = 0 ORDER BY t0 . date_add DESC LIMIT 4 ;
Copy
0.96 ms (11.09%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . price AS price_3 , t0 . description AS description_4 , t0 . is_archive AS is_archive_5 , t0 . date_add AS date_add_6 , t0 . end_date AS end_date_7 , t0 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = ? ORDER BY t0 . end_date ASC LIMIT 4
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . price AS price_3 , t0 . description AS description_4 , t0 . is_archive AS is_archive_5 , t0 . date_add AS date_add_6 , t0 . end_date AS end_date_7 , t0 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = 0 ORDER BY t0 . end_date ASC LIMIT 4 ;
Copy
0.51 ms (5.92%)
2
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC
SELECT id FROM goods . proposal WHERE (NOT is_private ) AND (NOT is_archive ) ORDER BY date_add DESC ;
Copy
0.32 ms (3.71%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . price AS price_3 , t0 . description AS description_4 , t0 . is_archive AS is_archive_5 , t0 . date_add AS date_add_6 , t0 . end_date AS end_date_7 , t0 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = ? LIMIT 100
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . price AS price_3 , t0 . description AS description_4 , t0 . is_archive AS is_archive_5 , t0 . date_add AS date_add_6 , t0 . end_date AS end_date_7 , t0 . items_count AS items_count_8 , t0 . payload AS payload_9 , t0 . category_id AS category_id_10 , t0 . owner_id AS owner_id_11 FROM goods . price_request t0 WHERE t0 . is_archive = 0 LIMIT 100 ;
Copy