2.49 ms
(35.16%)
|
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, product_name_2 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, p0_.is_new AS is_new_13, c1_.id AS id_14, c1_.name AS name_15, c1_.description AS description_16, c1_.slug AS slug_17, c1_.image AS image_18, c1_.banner AS banner_19 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) dctrn_result_inner ORDER BY product_name_2 ASC) dctrn_result LIMIT 15 OFFSET 315
Parameters: [
4
5
8
9
10
11
12
16
18
]
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, product_name_2 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, p0_.is_new AS is_new_13, c1_.id AS id_14, c1_.name AS name_15, c1_.description AS description_16, c1_.slug AS slug_17, c1_.image AS image_18, c1_.banner AS banner_19 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.id IN (4, 5, 8, 9, 10, 11, 12, 16, 18)) dctrn_result_inner ORDER BY product_name_2 ASC) dctrn_result LIMIT 15 OFFSET 315;
|
1.12 ms
(15.74%)
|
1 |
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, p0_.is_new AS is_new_13 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.product_name ASC) dctrn_result) dctrn_table
Parameters: [
4
5
8
9
10
11
12
16
18
]
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, p0_.is_new AS is_new_13 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.id IN (4, 5, 8, 9, 10, 11, 12, 16, 18) ORDER BY p0_.product_name ASC) dctrn_result) dctrn_table;
|
0.92 ms
(12.96%)
|
1 |
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_.is_new AS is_new_13, p0_.category_id AS category_id_14, p0_.supplier_id AS supplier_id_15 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.product_name ASC
Parameters: [
4
5
8
9
10
11
12
16
18
b"\x01š“µê\x12t%¤(Äç]ÈùÓ"
b"\x01š“µéåxw€A±ü\x14ȹ4"
b"\x01š“µé\x0Fxž‰\x14\x0E”\e”\x00©"
b"\x01š“µé(p£¡Œ9Òô\x0E“"
b"\x01š“µõ‘{/¨wòLµ§uy"
b"\x01š“µõˆ\x7F\x05”=bÃ*¬ùü"
b"""
\x01š“µõŽ|û ìê\n
µéR!
"""
b"\x01š“µõ~a¼\v—˜Ëò"
b"\x01š“µõŒtǹ\x14\x16õ\vϱŸ"
b"\x01š“µõ‹r“±\x11™ŸÑH\x05ô"
b"""
\x01š“µõ‰u\r¬6âÏÍ\n
QL
"""
b"\x01š“µõŒtǹ\x14\x16õ\vRøÊ"
b"\x01š“µõ~a¼\v—U+h"
b"\x01š“µõ‹r“±\x11™ŸÑŽìp"
b"\x01š“µõŠtQ¹êÄ!ž\x1CTV"
]
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_.is_new AS is_new_13, p0_.category_id AS category_id_14, p0_.supplier_id AS supplier_id_15 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.id IN (4, 5, 8, 9, 10, 11, 12, 16, 18) AND p0_.id IN (0x019A93B5EA127425A428C4E75DC8F9D3, 0x019A93B5E9E578778041B1FC14C8B934, 0x019A93B5E90F789E89140E941B9400A9, 0x019A93B5E92870A3A18C39D28FF40E93, 0x019A93B5F5917B2FA877F24CB5A77579, 0x019A93B5F5887F05943D62C32AACF9FC, 0x019A93B5F58D7CFBA0ECEA0AB5E95221, 0x019A93B5F5907E6190BC900B9798CBF2, 0x019A93B5F58C74C7B91416F50BCFB19F, 0x019A93B5F58B7293B111999FD14805F4, 0x019A93B5F589750DAC36E2CFCD0A514C, 0x019A93B5F58C74C7B91416F50B52F8CA, 0x019A93B5F5907E6190BC900B97552B68, 0x019A93B5F58B7293B111999FD18EEC70, 0x019A93B5F58A7451B9EAC4219E1C5456) ORDER BY p0_.product_name ASC;
|
0.88 ms
(12.43%)
|
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.banner AS banner_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"equipement"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.banner AS banner_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.slug = 'equipement' LIMIT 1;
|
0.32 ms
(4.58%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.banner AS banner_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.banner AS banner_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.parent_id = 3;
|
0.32 ms
(4.57%)
|
1 |
SELECT t0.id AS id_1, t0.phone_number AS phone_number_2, t0.address AS address_3, t0.facebook AS facebook_4, t0.tiktok AS tiktok_5, t0.instagram AS instagram_6, t0.linkedin AS linkedin_7, t0.logo AS logo_8, t0.google_maps_embed AS google_maps_embed_9 FROM information t0 LIMIT 1
SELECT t0.id AS id_1, t0.phone_number AS phone_number_2, t0.address AS address_3, t0.facebook AS facebook_4, t0.tiktok AS tiktok_5, t0.instagram AS instagram_6, t0.linkedin AS linkedin_7, t0.logo AS logo_8, t0.google_maps_embed AS google_maps_embed_9 FROM information t0 LIMIT 1;
|
0.28 ms
(3.95%)
|
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.logo AS logo_3, b0_.position AS position_4, CASE WHEN b0_.position IS NULL THEN 1 ELSE 0 END AS sclr_5 FROM brand b0_ ORDER BY sclr_5 ASC, b0_.position ASC, b0_.name ASC
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.logo AS logo_3, b0_.position AS position_4, CASE WHEN b0_.position IS NULL THEN 1 ELSE 0 END AS sclr_5 FROM brand b0_ ORDER BY sclr_5 ASC, b0_.position ASC, b0_.name ASC;
|
0.26 ms
(3.72%)
|
1 |
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;
|
0.25 ms
(3.52%)
|
1 |
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;
|
0.24 ms
(3.37%)
|
1 |
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;
|