2.06 ms (45.47%)
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
1.37 ms (30.30%)
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 = '402' ;
Copy
0.67 ms (14.84%)
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.24 ms (5.21%)
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 = 402 ORDER BY t0 . quantity ASC ;
Copy
0.19 ms (4.18%)
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 = 9 ;
Copy