| 0.0003 |
SELECT *
FROM `option`
ORDER BY `option_name` ASC
|
| 0.0023 |
SELECT *
FROM `weather`
WHERE `date` IN('03 Décembre', '04 Décembre', '05 Décembre')
LIMIT 3
|
| 0.0002 |
SELECT *
FROM `menu`
WHERE `published` = 1
AND `published` != 10
AND `position` = 'main'
ORDER BY `parent_id` ASC, `hierarchy` ASC, `title` ASC
|
| 0.0013 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-03 08:09:13'
AND `published` = 1
AND `article_category`.`category_id` IN('3')
AND `on_home` = 1
AND `publication_date` >= '2020-11-23 08:09:13'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0011 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-03 08:09:13'
AND `published` = 1
AND `article_category`.`category_id` IN('7')
AND `on_home` = 1
AND `publication_date` >= '2020-11-23 08:09:13'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0011 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-03 08:09:13'
AND `published` = 1
AND `article_category`.`category_id` IN('9')
AND `on_home` = 1
AND `publication_date` >= '2020-11-23 08:09:13'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0012 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-03 08:09:13'
AND `published` = 1
AND `article_category`.`category_id` IN('42')
AND `on_home` = 1
AND `publication_date` >= '2020-11-23 08:09:13'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0010 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-03 08:09:13'
AND `published` = 1
AND `article_category`.`category_id` IN('8')
AND `on_home` = 1
AND `publication_date` >= '2020-11-23 08:09:13'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0001 |
SELECT *
FROM `menu`
WHERE `published` = 1
AND `published` != 10
AND `position` = 'side'
ORDER BY `parent_id` ASC, `hierarchy` ASC, `title` ASC
|
| 0.0001 |
SELECT *
FROM `menu`
WHERE `published` = 1
AND `published` != 10
AND `rss` = 1
ORDER BY `parent_id` ASC, `hierarchy` ASC, `title` ASC
|
| 0.0001 |
SELECT *
FROM `contact`
WHERE `published` = 1
AND `published` != 10
AND `main` = 1
ORDER BY `id` DESC
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `category`
WHERE `published` = 1
AND `hierarchy` != 0
ORDER BY `published` DESC, `hierarchy` ASC
|
| 0.0001 |
SELECT DISTINCT(type_id)
FROM `comment`
JOIN `article` ON `type_id`=`article`.`id`
WHERE `article`.`published` = 1
AND `approved` = 1
AND `type` = 'article'
ORDER BY `comment`.`created_at` DESC
LIMIT 4
|
| 0.0004 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id` AND `default`=1
WHERE `published` != 10
AND `publication_date` <= '2020-12-03 08:09:13'
AND `published` = 1
AND `article_category`.`category_id` NOT IN(17, 46)
ORDER BY `publication_date` DESC
LIMIT 6
|
| 0.0001 |
SELECT `category`.`id`, `category`.`name`, `category`.`slug`
FROM `category`
JOIN `article_category` ON `article_category`.`category_id`=`category`.`id`
WHERE `default` = 1
AND `article_id` = '12668'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12668'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12668'
AND `type` = 'article'
AND `approved` = 1
ORDER BY `created_at` DESC
|
| 0.0001 |
SELECT *
FROM `tag`
JOIN `tag_article` ON `id`=`tag_id`
WHERE `article_id` = '12668'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12668'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT `category`.`id`, `category`.`name`, `category`.`slug`
FROM `category`
JOIN `article_category` ON `article_category`.`category_id`=`category`.`id`
WHERE `default` = 1
AND `article_id` = '12667'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12667'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12667'
AND `type` = 'article'
AND `approved` = 1
ORDER BY `created_at` DESC
|
| 0.0001 |
SELECT *
FROM `tag`
JOIN `tag_article` ON `id`=`tag_id`
WHERE `article_id` = '12667'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12667'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT `category`.`id`, `category`.`name`, `category`.`slug`
FROM `category`
JOIN `article_category` ON `article_category`.`category_id`=`category`.`id`
WHERE `default` = 1
AND `article_id` = '12666'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12666'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12666'
AND `type` = 'article'
AND `approved` = 1
ORDER BY `created_at` DESC
|
| 0.0001 |
SELECT *
FROM `tag`
JOIN `tag_article` ON `id`=`tag_id`
WHERE `article_id` = '12666'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12666'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT `category`.`id`, `category`.`name`, `category`.`slug`
FROM `category`
JOIN `article_category` ON `article_category`.`category_id`=`category`.`id`
WHERE `default` = 1
AND `article_id` = '12665'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12665'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12665'
AND `type` = 'article'
AND `approved` = 1
ORDER BY `created_at` DESC
|
| 0.0001 |
SELECT *
FROM `tag`
JOIN `tag_article` ON `id`=`tag_id`
WHERE `article_id` = '12665'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12665'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT `category`.`id`, `category`.`name`, `category`.`slug`
FROM `category`
JOIN `article_category` ON `article_category`.`category_id`=`category`.`id`
WHERE `default` = 1
AND `article_id` = '12664'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12664'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12664'
AND `type` = 'article'
AND `approved` = 1
ORDER BY `created_at` DESC
|
| 0.0001 |
SELECT *
FROM `tag`
JOIN `tag_article` ON `id`=`tag_id`
WHERE `article_id` = '12664'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12664'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT `category`.`id`, `category`.`name`, `category`.`slug`
FROM `category`
JOIN `article_category` ON `article_category`.`category_id`=`category`.`id`
WHERE `default` = 1
AND `article_id` = '12663'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12663'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12663'
AND `type` = 'article'
AND `approved` = 1
ORDER BY `created_at` DESC
|
| 0.0001 |
SELECT *
FROM `tag`
JOIN `tag_article` ON `id`=`tag_id`
WHERE `article_id` = '12663'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12663'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT *
FROM `poll`
WHERE `type` = 'poll'
ORDER BY `created_at` DESC
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `weather`
WHERE `date` = '03 Décembre'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `saints`
WHERE `jour` = '3'
AND `mois` = '12'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `folders`
WHERE `published` = '1'
ORDER BY `hierarchy` DESC, `created_at` DESC
LIMIT 5
|
| 0.0001 |
SELECT *
FROM `scores`
WHERE `type` = 'football'
AND `date` <= '2020-12-03'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `scores`
WHERE `type` = 'football2'
AND `date` <= '2020-12-03'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `scores`
WHERE `type` = 'football_f'
AND `date` <= '2020-12-03'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `scores`
WHERE `type` = 'basketball'
AND `date` <= '2020-12-03'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `scores`
WHERE `type` = 'basketball_f'
AND `date` <= '2020-12-03'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `scores`
WHERE `type` = 'rugby'
AND `date` <= '2020-12-03'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `scores_rank`
WHERE `id` = 1
ORDER BY `id` ASC
|
| 0.0001 |
SELECT *
FROM `scores_rank`
WHERE `id` = 2
ORDER BY `id` ASC
|
