| # | Time | Query |
|---|
| 1 |
1.96 ms |
SELECT url, namespace, method, content_redirection FROM `redirect` WHERE status = 1 |
| 2 |
6.2 ms |
INSERT INTO `log_customer` ( `id` , `id_customer` , `log` , `date` ) VALUES( NULL , NULL ,... |
| 3 |
0.4 ms |
SELECT * FROM `languages` WHERE TRUE AND `short` = 'en' |
| 4 |
0.64 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 |
| 5 |
0.34 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 |
| 6 |
0.29 ms |
SELECT * FROM `languages` WHERE TRUE AND `name` = 'English' |
| 7 |
0.49 ms |
SELECT c.*, m.id_language, m.name, m.description, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt FROM `categories` AS c INNER JOIN `category_meta` AS m on c.id = m.id_category WHERE TRUE AND c.`id` = 240 AND c.`status` = '32' AND m.`id_language` = 1 LIMIT 0 , 30 |
| 8 |
0.44 ms |
SELECT * FROM `type` WHERE TRUE AND `id` = 31 ORDER BY `id` DESC LIMIT 0 , 30 |
| 9 |
0.48 ms |
SELECT * FROM `category_parent` WHERE TRUE AND `id_child` = 240 ORDER BY `id` DESC LIMIT 0 , 30 |
| 10 |
0.37 ms |
SELECT c.*, m.id_language, m.name, m.description, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt FROM `category_parent` AS cp INNER JOIN categories AS c on c.id=cp.id_child INNER JOIN `category_meta` AS m on c.id=m.id_category WHERE TRUE AND cp.`id_parent` = 240 AND... |
| 11 |
1.49 ms |
SELECT d.*, m.id_language, m.name, m.description, m.summary, m.seo_title, m.seo_description, m.seo_keywords, m.seo_url, m.img_alt, (select name from type where id = d.type) as nameType, (select name from status where id = d.status) as statusName FROM `destinations` AS d INNER JOIN... |
| 12 |
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` = 'products_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 13 |
0.54 ms |
SELECT *, CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(REPLACE(name,'_',' '), 2))) as title FROM `status` WHERE TRUE AND `name` = 'active' AND `group` = 'suppliers_status' ORDER BY `id` DESC LIMIT 0 , 30 |
| 14 |
0.74 ms |
SELECT * FROM `category_parent` WHERE TRUE AND `id_parent` = 240 ORDER BY `id` DESC LIMIT 0 , 30 |
| 15 |
2.95 ms |
SELECT s.seo_title, s.seo_description, s.seo_keywords, s.seo_url, p.*, (select count(*) from reviews where id_product = p.id and status in (select id from status s where s.name = 'active' and s.group = 'review_status')) as total_review, (select name from type where id = p.product_type) as type,... |
| 16 |
1.13 ms |
SELECT reviews.id, reviews.id_product,reviews.id_customer ,reviews.title, reviews.text, reviews.date, reviews.rating_overall, reviews.display_name FROM reviews JOIN status ON status.id = reviews.status WHERE id_product IN ( SELECT pc.id_product FROM product_category pc INNER JOIN products p ON... |
| 17 |
1.33 ms |
SELECT COUNT(reviews.id) as number,AVG(reviews.rating_overall) as avg FROM `reviews` JOIN status ON status.id = reviews.status WHERE id_product IN (SELECT id_product FROM `product_category` WHERE `id_category` = 240) AND status.name = "active" ORDER BY reviews.`id` DESC LIMIT 0 , 30 |
| 18 |
1.08 ms |
SELECT *, (SELECT IF (JSON_VALID(content),JSON_UNQUOTE(JSON_EXTRACT(content,'$.content' )),NULL) FROM items where id_section = (SELECT id from section where id_article = ar.id order by orders limit 1) and type = 4 order by orders limit 1) as title, (SELECT IF... |