| # | Time | Query |
|---|
| 1 |
1.99 ms |
SELECT * FROM `setting` WHERE TRUE |
| 2 |
5.15 ms |
INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL , '{\"method\":\"GET\",\"user_id\":null,\"role\":\"customer\",\"ip\":\"216.73.216.141\",\"root_url\":\"dotravel.staging.dev.kickersoft.com\",\"request\":\"\\/\",\"part\":\"page\",\"action\":\"index\"}' ,... |
| 3 |
1.69 ms |
SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 |
0.96 ms |
SELECT * FROM `setting` WHERE TRUE AND `st_group` = 'fileServices' AND `st_key` = 'currency' |
| 5 |
0.99 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'destinations_type' AND `name` = 'country' ORDER BY `id` DESC LIMIT 0 , 30 |
| 6 |
1.01 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'destinations_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 7 |
0.27 ms |
SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 8 |
4.93 ms |
SELECT d.*, d.cdn_image_uuid, d.cdn_variants, d.cdn_processing_status, d.use_cdn, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, m.faqs, m.index_content FROM `destinations` AS d INNER JOIN `destination_meta` AS m on d.id =... |
| 9 |
2.14 ms |
SELECT * FROM `destination_meta` WHERE `id_destination` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND `id_language` = ? |
| 10 |
0.55 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'categories_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 11 |
0.82 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'published' AND `group` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 12 |
11.21 ms |
SELECT p.* FROM `products` p JOIN `suppliers` s ON p.id_supplier = s.id JOIN `status` st ON s.status = st.id WHERE TRUE AND st.name = 'active' AND st.group = 'suppliers_status' AND p.`status` = '23' ORDER BY p.`id` desc LIMIT 0 , 20 |
| 13 |
0.66 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'review_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 14 |
0.38 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'sub_product_type' AND `name` = 'group' ORDER BY `id` DESC LIMIT 0 , 30 |
| 15 |
4.28 ms |
SELECT id_product, id_language FROM `sub_product` WHERE id_product IN (4790,4789,4788,4787,4786,4785,4784,4783,4782,4781,4780,4779,4778,4777,4775,4772,4771,4770,4768,4767) AND type = 4 ORDER BY id_language ASC |
| 16 |
0.83 ms |
SELECT * FROM `languages` WHERE TRUE AND `id` = 1 |
| 17 |
3.84 ms |
SELECT id_product, seo_url FROM `seo` WHERE id_product IN (4790,4789,4788,4787,4786,4785,4784,4783,4782,4781,4780,4779,4778,4777,4775,4772,4771,4770,4768,4767) AND id_language = ? |
| 18 |
9.55 ms |
SELECT id_product, metaname, metavalue FROM `product_meta` WHERE id_product IN (4790,4789,4788,4787,4786,4785,4784,4783,4782,4781,4780,4779,4778,4777,4775,4772,4771,4770,4768,4767) AND metaname IN ('title','summary','typeHour','currency') AND id_language = 1 |
| 19 |
4.77 ms |
SELECT pp.* FROM `product_photos` pp INNER JOIN ( SELECT id_product, MIN(show_order) AS min_order FROM `product_photos` WHERE id_product IN (4790,4789,4788,4787,4786,4785,4784,4783,4782,4781,4780,4779,4778,4777,4775,4772,4771,4770,4768,4767) GROUP BY id_product ) first ON pp.id_product =... |
| 20 |
3.08 ms |
SELECT id_product, SUM(rating_overall) / COUNT(*) AS rating_overall, COUNT(*) AS review_count FROM `reviews` WHERE id_product IN (4790,4789,4788,4787,4786,4785,4784,4783,4782,4781,4780,4779,4778,4777,4775,4772,4771,4770,4768,4767) AND status = 26 GROUP BY id_product |
| 21 |
3.07 ms |
SELECT s.id_product, MIN(pr.price) AS min FROM `product_prices` pr INNER JOIN `sub_product` s ON s.id = pr.id_subproduct INNER JOIN `age_group` a ON a.id = pr.id_agegroup WHERE s.id_product IN (4790,4789,4788,4787,4786,4785,4784,4783,4782,4781,4780,4779,4778,4777,4775,4772,4771,4770,4768,4767)... |
| 22 |
0.47 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 2 ORDER BY `id` DESC LIMIT 0 , 30 |
| 23 |
0.38 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `id` = '23' ORDER BY `id` DESC LIMIT 0 , 30 |
| 24 |
2.12 ms |
SELECT * FROM `product_system` WHERE id_product_dotravel IN (4790,4789,4788,4787,4786,4785,4784,4783,4782,4781,4780,4779,4778,4777,4775,4772,4771,4770,4768,4767) |
| 25 |
2.04 ms |
SELECT id_product, metavalue FROM `product_meta` WHERE id_product IN (4790,4789,4788,4787,4786,4785,4784,4783,4782,4781,4780,4779,4778,4777,4775,4772,4771,4770,4768,4767) AND metaname = ? AND id_language = ? |
| 26 |
1.16 ms |
SELECT DISTINCT id_destination FROM product_destination WHERE id_product IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) |
| 27 |
49.45 ms |
SELECT DISTINCT p.*, pm.metavalue AS availability_next_date FROM products p JOIN suppliers s ON p.id_supplier = s.id JOIN status st ON s.status = st.id JOIN product_destination pd ON pd.id_product = p.id JOIN product_meta pm ON pm.id_product = p.id AND pm.metaname = 'availability_next_date' AND... |
| 28 |
0.63 ms |
SELECT id_product, id_language FROM `sub_product` WHERE id_product IN (4694,4695,4757,4764,4766) AND type = 4 ORDER BY id_language ASC |
| 29 |
0.35 ms |
SELECT id_product, seo_url FROM `seo` WHERE id_product IN (4694,4695,4757,4764,4766) AND id_language = ? |
| 30 |
0.64 ms |
SELECT id_product, metaname, metavalue FROM `product_meta` WHERE id_product IN (4694,4695,4757,4764,4766) AND metaname IN ('title','summary','typeHour','currency') AND id_language = 1 |
| 31 |
1.57 ms |
SELECT pp.* FROM `product_photos` pp INNER JOIN ( SELECT id_product, MIN(show_order) AS min_order FROM `product_photos` WHERE id_product IN (4694,4695,4757,4764,4766) GROUP BY id_product ) first ON pp.id_product = first.id_product AND pp.show_order = first.min_order WHERE pp.id_product IN... |
| 32 |
0.32 ms |
SELECT id_product, SUM(rating_overall) / COUNT(*) AS rating_overall, COUNT(*) AS review_count FROM `reviews` WHERE id_product IN (4694,4695,4757,4764,4766) AND status = 26 GROUP BY id_product |
| 33 |
0.42 ms |
SELECT s.id_product, MIN(pr.price) AS min FROM `product_prices` pr INNER JOIN `sub_product` s ON s.id = pr.id_subproduct INNER JOIN `age_group` a ON a.id = pr.id_agegroup WHERE s.id_product IN (4694,4695,4757,4764,4766) AND pr.price > 0 GROUP BY s.id_product |
| 34 |
0.26 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 1 ORDER BY `id` DESC LIMIT 0 , 30 |
| 35 |
0.74 ms |
SELECT * FROM `type` WHERE TRUE AND `group` = 'products_product_type' AND `name` = 'ticket' ORDER BY `id` DESC LIMIT 0 , 30 |
| 36 |
3.64 ms |
SELECT p.* FROM `products` p JOIN `suppliers` s ON p.id_supplier = s.id JOIN `status` st ON s.status = st.id WHERE TRUE AND st.name = 'active' AND st.group = 'suppliers_status' AND p.`product_type` = 1 AND p.`status` = '23' ORDER BY p.`id` desc LIMIT 0 , 12 |
| 37 |
0.8 ms |
SELECT id_product, id_language FROM `sub_product` WHERE id_product IN (4731,4726,4710,4709,4708,4707,4706,4705,4704,4703,4702,4701) AND type = 4 ORDER BY id_language ASC |
| 38 |
1.09 ms |
SELECT id_product, seo_url FROM `seo` WHERE id_product IN (4731,4726,4710,4709,4708,4707,4706,4705,4704,4703,4702,4701) AND id_language = ? |
| 39 |
1.76 ms |
SELECT id_product, metaname, metavalue FROM `product_meta` WHERE id_product IN (4731,4726,4710,4709,4708,4707,4706,4705,4704,4703,4702,4701) AND metaname IN ('title','summary','typeHour','currency') AND id_language = 1 |
| 40 |
1.12 ms |
SELECT pp.* FROM `product_photos` pp INNER JOIN ( SELECT id_product, MIN(show_order) AS min_order FROM `product_photos` WHERE id_product IN (4731,4726,4710,4709,4708,4707,4706,4705,4704,4703,4702,4701) GROUP BY id_product ) first ON pp.id_product = first.id_product AND pp.show_order =... |
| 41 |
0.59 ms |
SELECT id_product, SUM(rating_overall) / COUNT(*) AS rating_overall, COUNT(*) AS review_count FROM `reviews` WHERE id_product IN (4731,4726,4710,4709,4708,4707,4706,4705,4704,4703,4702,4701) AND status = 26 GROUP BY id_product |
| 42 |
0.64 ms |
SELECT s.id_product, MIN(pr.price) AS min FROM `product_prices` pr INNER JOIN `sub_product` s ON s.id = pr.id_subproduct INNER JOIN `age_group` a ON a.id = pr.id_agegroup WHERE s.id_product IN (4731,4726,4710,4709,4708,4707,4706,4705,4704,4703,4702,4701) AND pr.price > 0 GROUP BY s.id_product |
| 43 |
0.78 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'articles_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 44 |
14.79 ms |
SELECT * FROM `articles` WHERE TRUE AND `status` = '44' ORDER BY `created_date` DESC LIMIT 0 , 4 |
| 45 |
3.11 ms |
SELECT au.*, s.name as status_name FROM `admin_user` au INNER JOIN status s ON s.id = au.status AND s.group = 'admin_user_status' WHERE TRUE AND au.`id` = 37 ORDER BY au.`id` DESC |
| 46 |
3.51 ms |
SELECT * FROM `article_photos` WHERE TRUE AND `id_article` = 147 ORDER BY `id` DESC LIMIT 0 , 30 |
| 47 |
0.53 ms |
SELECT au.*, s.name as status_name FROM `admin_user` au INNER JOIN status s ON s.id = au.status AND s.group = 'admin_user_status' WHERE TRUE AND au.`id` = 37 ORDER BY au.`id` DESC |
| 48 |
0.44 ms |
SELECT * FROM `article_photos` WHERE TRUE AND `id_article` = 146 ORDER BY `id` DESC LIMIT 0 , 30 |
| 49 |
0.38 ms |
SELECT au.*, s.name as status_name FROM `admin_user` au INNER JOIN status s ON s.id = au.status AND s.group = 'admin_user_status' WHERE TRUE AND au.`id` = 37 ORDER BY au.`id` DESC |
| 50 |
0.29 ms |
SELECT * FROM `article_photos` WHERE TRUE AND `id_article` = 145 ORDER BY `id` DESC LIMIT 0 , 30 |
| 51 |
0.27 ms |
SELECT au.*, s.name as status_name FROM `admin_user` au INNER JOIN status s ON s.id = au.status AND s.group = 'admin_user_status' WHERE TRUE AND au.`id` = 37 ORDER BY au.`id` DESC |
| 52 |
0.29 ms |
SELECT * FROM `article_photos` WHERE TRUE AND `id_article` = 144 ORDER BY `id` DESC LIMIT 0 , 30 |
.jpg)
.jpg)
