| 1 |
1.13 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.is_in_selection AS is_in_selection_12 FROM product p0_) dctrn_result) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.is_in_selection AS is_in_selection_12 FROM product p0_) dctrn_result) dctrn_table;
|
| 2 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.illustration AS illustration_3, t0.slug AS slug_4, t0.banner AS banner_5 FROM job t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.illustration AS illustration_3, t0.slug AS slug_4, t0.banner AS banner_5 FROM job t0;
|
| 3 |
0.27 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.image AS image_4, c0_.banner AS banner_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.parent_id IS NOT NULL
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.image AS image_4, c0_.banner AS banner_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.parent_id IS NOT NULL;
|
| 4 |
0.29 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.image AS image_4, c0_.banner AS banner_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.parent_id IS NULL
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.image AS image_4, c0_.banner AS banner_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.parent_id IS NULL;
|
| 5 |
2.03 ms |
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.is_in_selection AS is_in_selection_13, t0.category_id AS category_id_14, t0.supplier_id AS supplier_id_15 FROM product t0
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.is_in_selection AS is_in_selection_13, t0.category_id AS category_id_14, t0.supplier_id AS supplier_id_15 FROM product t0;
|
| 6 |
0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4 FROM brand t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4 FROM brand t0;
|
| 7 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.body AS body_3, t0.slug AS slug_4, t0.banner AS banner_5, t0.category_id AS category_id_6 FROM standard t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.body AS body_3, t0.slug AS slug_4, t0.banner AS banner_5, t0.category_id AS category_id_6 FROM standard t0;
|
| 8 |
0.56 ms |
SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.is_in_selection AS is_in_selection_12 FROM product p0_) dctrn_result LIMIT 15 OFFSET 705
SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.is_in_selection AS is_in_selection_12 FROM product p0_) dctrn_result LIMIT 15 OFFSET 705;
|
| 9 |
0.43 ms |
SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.is_in_selection AS is_in_selection_12, p0_.category_id AS category_id_13, p0_.supplier_id AS supplier_id_14 FROM product p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
b"\x01š“µéµ{ýªÏÀû¦²/_"
b"\x01š“µé¶\x7F⟖í„\x19§9Z"
b"\x01š“µé·{C½[‚¨é\e\x08"
b"\x01š“µé¸qL¡#£\x0FÆ„e\x19"
b"\x01š“µé¹|Šw\Zêë¤ã"
b"\x01š“µéºuÁ–€dx\x13yÚ"
b"\x01š“µé»xȲl\x1C4¯‡<"
b"\x01š“µé¼t\x01œÉ¤º\x00='C"
b"\x01š“µé½uy™}o\x00^={U"
b"\x01š“µé¾}8‹ºOB¶\x17·\x01"
b"\x01š“µé¿}\x1F‰<yÂ9\eí"
b"\x01š“µéÀ{\x1AªµºXkã\x02\x16"
b"\x01š“µïË\x7FÇŠ\vqUX?$Ù"
b"\x01š“µïÌ~n¡Áñkè…µ"
b"\x01š“µïÍ~Œ§|“\x0E nU\x03"
]
SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.is_in_selection AS is_in_selection_12, p0_.category_id AS category_id_13, p0_.supplier_id AS supplier_id_14 FROM product p0_ WHERE p0_.id IN (0x019A93B5E9B57BFDAACFC0FBA6B22F5F, 0x019A93B5E9B67FE29F96ED8419A7395A, 0x019A93B5E9B77B43BD5B82A8E91B08AD, 0x019A93B5E9B8714CA123A30FC6846519, 0x019A93B5E9B97C8F8A775C5AEAEBA4E3, 0x019A93B5E9BA75C1968064AD781379DA, 0x019A93B5E9BB78C8B26C1C8134AF873C, 0x019A93B5E9BC74019CC9A4BA003D2743, 0x019A93B5E9BD7579997D6F005E3D7B55, 0x019A93B5E9BE7D388BBA4F42B617B701, 0x019A93B5E9BF7D1F893C79C2398F1BED, 0x019A93B5E9C07B1AAAB5BA586BE30216, 0x019A93B5EFCB7FC78A0B7155583F24D9, 0x019A93B5EFCC7E6EA1ADC1F16BE885B5, 0x019A93B5EFCD7E8CA77C930E206E5503);
|