1.86 ms (61.75%)
8
SELECT t0 . id AS id_1 , t0 . label AS label_2 , t0 . priority AS priority_3 , t0 . image AS image_4 , t0 . parent_id AS parent_id_5 , t6 . id AS id_7 , t6 . label AS label_8 , t6 . priority AS priority_9 , t6 . image AS image_10 , t6 . parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0 . parent_id = t6 . id WHERE t0 . parent_id = ? ORDER BY t0 . priority ASC
SELECT t0 . id AS id_1 , t0 . label AS label_2 , t0 . priority AS priority_3 , t0 . image AS image_4 , t0 . parent_id AS parent_id_5 , t6 . id AS id_7 , t6 . label AS label_8 , t6 . priority AS priority_9 , t6 . image AS image_10 , t6 . parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0 . parent_id = t6 . id WHERE t0 . parent_id = 1 ORDER BY t0 . priority ASC ;
Copy
0.38 ms (12.49%)
1
SELECT t0 . id AS id_1 , t0 . label AS label_2 , t0 . priority AS priority_3 , t0 . image AS image_4 , t0 . parent_id AS parent_id_5 , t6 . id AS id_7 , t6 . label AS label_8 , t6 . priority AS priority_9 , t6 . image AS image_10 , t6 . parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0 . parent_id = t6 . id WHERE t0 . parent_id IS NULL ORDER BY t0 . priority ASC
SELECT t0 . id AS id_1 , t0 . label AS label_2 , t0 . priority AS priority_3 , t0 . image AS image_4 , t0 . parent_id AS parent_id_5 , t6 . id AS id_7 , t6 . label AS label_8 , t6 . priority AS priority_9 , t6 . image AS image_10 , t6 . parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0 . parent_id = t6 . id WHERE t0 . parent_id IS NULL ORDER BY t0 . priority ASC ;
Copy
0.34 ms (11.40%)
1
SELECT t0 . id AS id_1 , t0 . class AS class_2 , t0 . name AS name_3 , t0 . item_number AS item_number_4 , t0 . size AS size_5 , t0 . shape AS shape_6 , t0 . quantity AS quantity_7 , t0 . weight AS weight_8 , t0 . is_viewable AS is_viewable_9 , t0 . notes AS notes_10 , t0 . image AS image_11 , t0 . product_category_id AS product_category_id_12 , t0 . material_id AS material_id_13 FROM product t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . class AS class_2 , t0 . name AS name_3 , t0 . item_number AS item_number_4 , t0 . size AS size_5 , t0 . shape AS shape_6 , t0 . quantity AS quantity_7 , t0 . weight AS weight_8 , t0 . is_viewable AS is_viewable_9 , t0 . notes AS notes_10 , t0 . image AS image_11 , t0 . product_category_id AS product_category_id_12 , t0 . material_id AS material_id_13 FROM product t0 WHERE t0 . id = '921' ;
Copy
0.26 ms (8.60%)
1
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . price AS price_3 , t0 . label AS label_4 , t0 . product_id AS product_id_5 FROM product_quantity t0 WHERE t0 . product_id = ? ORDER BY t0 . quantity ASC
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . price AS price_3 , t0 . label AS label_4 , t0 . product_id AS product_id_5 FROM product_quantity t0 WHERE t0 . product_id = 921 ORDER BY t0 . quantity ASC ;
Copy
0.17 ms (5.75%)
1
SELECT t0 . id AS id_1 , t0 . material AS material_2 FROM material t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . material AS material_2 FROM material t0 WHERE t0 . id = 8 ;
Copy