1.85 ms (61.07%)
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.39 ms (12.75%)
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.36 ms (11.77%)
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 = '1108' ;
Copy
0.23 ms (7.51%)
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 = 1108 ORDER BY t0 . quantity ASC ;
Copy
0.21 ms (6.89%)
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 = 6 ;
Copy