1
26.11 ms
SELECT s0_ . lang AS lang_0 FROM setting s0_ WHERE s0_ . id > = 1
SELECT s0_ . lang AS lang_0 FROM setting s0_ WHERE s0_ . id > = 1 ; Copy
2
7.35 ms
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . title AS title_3 , t0 . keywords AS keywords_4 , t0 . description AS description_5 , t0 . about AS about_6 , t0 . contact AS contact_7 FROM setting_lang t0 WHERE t0 . lang = ? ORDER BY t0 . id ASC LIMIT 1
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . title AS title_3 , t0 . keywords AS keywords_4 , t0 . description AS description_5 , t0 . about AS about_6 , t0 . contact AS contact_7 FROM setting_lang t0 WHERE t0 . lang = 'tr' ORDER BY t0 . id ASC LIMIT 1 ; Copy
3
8.10 ms
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . title AS title_3 , t0 . keywords AS keywords_4 , t0 . description AS description_5 , t0 . category_id AS category_id_6 FROM category_lang t0 WHERE t0 . lang = ?
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . title AS title_3 , t0 . keywords AS keywords_4 , t0 . description AS description_5 , t0 . category_id AS category_id_6 FROM category_lang t0 WHERE t0 . lang = 'tr' ; Copy
4
49.52 ms
SELECT p0_ . id AS id_0 , p0_ . pcode AS pcode_1 , p0_ . image AS image_2 , p0_ . price AS price_3 , p0_ . quantity AS quantity_4 , p0_ . metal AS metal_5 , p0_ . weight AS weight_6 , p0_ . user_id AS user_id_7 , p0_ . status AS status_8 , p0_ . campaign AS campaign_9 , COALESCE (p1_ . title , p2_ . title ) AS sclr_10 , COALESCE (p1_ . description , p2_ . description ) AS sclr_11 , p0_ . pcode AS pcode_12 , p0_ . image AS image_13 , p0_ . price AS price_14 , p0_ . quantity AS quantity_15 , p0_ . metal AS metal_16 , p0_ . id AS id_17 , p0_ . status AS status_18 , p0_ . category_id AS category_id_19 FROM product p0_ LEFT JOIN product_lang p1_ ON p0_ . id = p1_ . product_id AND (p1_ . lang = ? ) LEFT JOIN product_lang p2_ ON p0_ . id = p2_ . product_id AND (p2_ . lang = ? ) WHERE p0_ . status = 1 LIMIT 12
Parameters :
[
"tr "
"en "
]
SELECT p0_ . id AS id_0 , p0_ . pcode AS pcode_1 , p0_ . image AS image_2 , p0_ . price AS price_3 , p0_ . quantity AS quantity_4 , p0_ . metal AS metal_5 , p0_ . weight AS weight_6 , p0_ . user_id AS user_id_7 , p0_ . status AS status_8 , p0_ . campaign AS campaign_9 , COALESCE (p1_ . title , p2_ . title ) AS sclr_10 , COALESCE (p1_ . description , p2_ . description ) AS sclr_11 , p0_ . pcode AS pcode_12 , p0_ . image AS image_13 , p0_ . price AS price_14 , p0_ . quantity AS quantity_15 , p0_ . metal AS metal_16 , p0_ . id AS id_17 , p0_ . status AS status_18 , p0_ . category_id AS category_id_19 FROM product p0_ LEFT JOIN product_lang p1_ ON p0_ . id = p1_ . product_id AND (p1_ . lang = 'tr' ) LEFT JOIN product_lang p2_ ON p0_ . id = p2_ . product_id AND (p2_ . lang = 'en' ) WHERE p0_ . status = 1 LIMIT 12 ; Copy
5
4.84 ms
SELECT p0_ . id AS id_0 , p0_ . pcode AS pcode_1 , p0_ . image AS image_2 , p0_ . price AS price_3 , p0_ . quantity AS quantity_4 , p0_ . metal AS metal_5 , p0_ . weight AS weight_6 , p0_ . user_id AS user_id_7 , p0_ . status AS status_8 , p0_ . campaign AS campaign_9 , COALESCE (p1_ . title , p2_ . title ) AS sclr_10 , COALESCE (p1_ . description , p2_ . description ) AS sclr_11 , p0_ . pcode AS pcode_12 , p0_ . image AS image_13 , p0_ . price AS price_14 , p0_ . quantity AS quantity_15 , p0_ . metal AS metal_16 , p0_ . id AS id_17 , p0_ . status AS status_18 , p0_ . category_id AS category_id_19 FROM product p0_ LEFT JOIN product_lang p1_ ON p0_ . id = p1_ . product_id AND (p1_ . lang = ? ) LEFT JOIN product_lang p2_ ON p0_ . id = p2_ . product_id AND (p2_ . lang = ? ) WHERE p0_ . status = 1 LIMIT 12
Parameters :
[
"tr "
"en "
]
SELECT p0_ . id AS id_0 , p0_ . pcode AS pcode_1 , p0_ . image AS image_2 , p0_ . price AS price_3 , p0_ . quantity AS quantity_4 , p0_ . metal AS metal_5 , p0_ . weight AS weight_6 , p0_ . user_id AS user_id_7 , p0_ . status AS status_8 , p0_ . campaign AS campaign_9 , COALESCE (p1_ . title , p2_ . title ) AS sclr_10 , COALESCE (p1_ . description , p2_ . description ) AS sclr_11 , p0_ . pcode AS pcode_12 , p0_ . image AS image_13 , p0_ . price AS price_14 , p0_ . quantity AS quantity_15 , p0_ . metal AS metal_16 , p0_ . id AS id_17 , p0_ . status AS status_18 , p0_ . category_id AS category_id_19 FROM product p0_ LEFT JOIN product_lang p1_ ON p0_ . id = p1_ . product_id AND (p1_ . lang = 'tr' ) LEFT JOIN product_lang p2_ ON p0_ . id = p2_ . product_id AND (p2_ . lang = 'en' ) WHERE p0_ . status = 1 LIMIT 12 ; Copy
6
9.43 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id is NULL AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id is NULL AND c . status = 1 ORDER BY cl . title ASC ; Copy
7
5.95 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 23 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 23 AND c . status = 1 ORDER BY cl . title ASC ; Copy
8
2.72 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 7 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 7 AND c . status = 1 ORDER BY cl . title ASC ; Copy
9
5.95 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 13 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 13 AND c . status = 1 ORDER BY cl . title ASC ; Copy
10
10.92 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 1 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 1 AND c . status = 1 ORDER BY cl . title ASC ; Copy
11
8.14 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 11 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 11 AND c . status = 1 ORDER BY cl . title ASC ; Copy
12
12.11 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 2 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 2 AND c . status = 1 ORDER BY cl . title ASC ; Copy
13
8.54 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 12 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 12 AND c . status = 1 ORDER BY cl . title ASC ; Copy
14
10.89 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 3 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 3 AND c . status = 1 ORDER BY cl . title ASC ; Copy
15
10.49 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id is NULL AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id is NULL AND c . status = 1 ORDER BY cl . title ASC ; Copy
16
10.90 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 23 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 23 AND c . status = 1 ORDER BY cl . title ASC ; Copy
17
6.40 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 7 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 7 AND c . status = 1 ORDER BY cl . title ASC ; Copy
18
10.59 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 13 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 13 AND c . status = 1 ORDER BY cl . title ASC ; Copy
19
3.87 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 1 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 1 AND c . status = 1 ORDER BY cl . title ASC ; Copy
20
1.08 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 11 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 11 AND c . status = 1 ORDER BY cl . title ASC ; Copy
21
2.65 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 2 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 2 AND c . status = 1 ORDER BY cl . title ASC ; Copy
22
2.98 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 12 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 12 AND c . status = 1 ORDER BY cl . title ASC ; Copy
23
4.02 ms
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 3 AND c . status = 1 ORDER BY cl . title ASC
SELECT c . id as catid , cl . title as title FROM category c JOIN category_lang cl on c . id = cl . category_id WHERE cl . lang = 'tr' AND c . parent_id = 3 AND c . status = 1 ORDER BY cl . title ASC ; Copy
24
9.29 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 1 ; Copy
25
3.79 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 2 ; Copy
26
1.84 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 3 ; Copy
27
10.54 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 7 ; Copy
28
13.35 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 8 ; Copy
29
10.95 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 9 ; Copy
30
10.80 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 10 ; Copy
31
1.84 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 11 ; Copy
32
12.24 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 12 ; Copy
33
2.87 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 13 ; Copy
34
0.36 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 14 ; Copy
35
0.41 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 15 ; Copy
36
0.33 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 16 ; Copy
37
0.31 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 17 ; Copy
38
0.55 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 18 ; Copy
39
0.49 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 19 ; Copy
40
0.41 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 20 ; Copy
41
0.94 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 21 ; Copy
42
0.50 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 22 ; Copy
43
0.42 ms
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . status AS status_3 , t0 . parent_id AS parent_id_4 FROM category t0 WHERE t0 . id = 23 ; Copy