| 0.0011 |
SELECT *
FROM `option`
ORDER BY `option_name` ASC
|
| 0.0009 |
SELECT `article`.*, IF(article_stat.total_page_views IS NULL, 0, article_stat.total_page_views) as total_page_views
FROM `article`
LEFT JOIN `article_stat` ON `article`.`id` = `article_stat`.`id`
WHERE `article`.`id` = '11370'
AND `published` != 10
AND `published` = 1
LIMIT 1
|
| 0.0008 |
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` = '11370'
LIMIT 1
|
| 0.0003 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '11370'
LIMIT 50
|
| 0.0007 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '11370'
AND `type` = 'article'
AND `approved` = 1
ORDER BY `created_at` DESC
|
| 0.0005 |
SELECT *
FROM `tag`
JOIN `tag_article` ON `id`=`tag_id`
WHERE `article_id` = '11370'
|
| 0.0006 |
SELECT *
FROM `article_file`
WHERE `article_id` = '11370'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0008 |
SELECT *
FROM `menu`
WHERE `published` = 1
AND `published` != 10
AND `position` = 'main'
ORDER BY `parent_id` ASC, `hierarchy` ASC, `title` ASC
|
| 0.0049 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-06 01:51:40'
AND `published` = 1
AND `article_category`.`category_id` IN('3')
AND `on_home` = 1
AND `publication_date` >= '2020-11-26 01:51:40'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0019 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-06 01:51:40'
AND `published` = 1
AND `article_category`.`category_id` IN('7')
AND `on_home` = 1
AND `publication_date` >= '2020-11-26 01:51:40'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0009 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-06 01:51:40'
AND `published` = 1
AND `article_category`.`category_id` IN('9')
AND `on_home` = 1
AND `publication_date` >= '2020-11-26 01:51:40'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0007 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-06 01:51:40'
AND `published` = 1
AND `article_category`.`category_id` IN('42')
AND `on_home` = 1
AND `publication_date` >= '2020-11-26 01:51:40'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0009 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-06 01:51:40'
AND `published` = 1
AND `article_category`.`category_id` IN('8')
AND `on_home` = 1
AND `publication_date` >= '2020-11-26 01:51:40'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `published` = 1
AND `published` != 10
AND `position` = 'side'
ORDER BY `parent_id` ASC, `hierarchy` ASC, `title` ASC
|
| 0.0002 |
SELECT *
FROM `menu`
WHERE `published` = 1
AND `published` != 10
AND `rss` = 1
ORDER BY `parent_id` ASC, `hierarchy` ASC, `title` ASC
|
| 0.0002 |
SELECT *
FROM `contact`
WHERE `published` = 1
AND `published` != 10
AND `main` = 1
ORDER BY `id` DESC
LIMIT 1
|
| 0.0003 |
SELECT *
FROM `category`
WHERE `published` = 1
AND `hierarchy` != 0
ORDER BY `published` DESC, `hierarchy` ASC
|
| 0.0002 |
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.0010 |
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-06 01:51:40'
AND `published` = 1
AND `article_category`.`category_id` NOT IN(17, 46)
ORDER BY `publication_date` DESC
LIMIT 6
|
| 0.0002 |
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` = '12674'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12674'
LIMIT 50
|
| 0.0003 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0002 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12674'
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` = '12674'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12674'
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` = '12673'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12673'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0002 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12673'
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` = '12673'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12673'
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` = '12672'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12672'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0002 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12672'
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` = '12672'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12672'
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` = '12671'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12671'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0002 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12671'
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` = '12671'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12671'
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` = '12670'
LIMIT 1
|
| 0.0002 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12670'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0002 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12670'
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` = '12670'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12670'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0002 |
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` = '12669'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '12669'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0002 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '12669'
AND `type` = 'article'
AND `approved` = 1
ORDER BY `created_at` DESC
|
| 0.0004 |
SELECT *
FROM `tag`
JOIN `tag_article` ON `id`=`tag_id`
WHERE `article_id` = '12669'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '12669'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0002 |
SELECT *
FROM `poll`
WHERE `type` = 'poll'
ORDER BY `created_at` DESC
LIMIT 1
|
| 0.0013 |
SELECT *
FROM `weather`
WHERE `date` = '06 Décembre'
LIMIT 1
|
| 0.0005 |
SELECT *
FROM `saints`
WHERE `jour` = '6'
AND `mois` = '12'
LIMIT 1
|
| 0.0004 |
SELECT *
FROM `folders`
WHERE `published` = '1'
ORDER BY `hierarchy` DESC, `created_at` DESC
LIMIT 5
|
| 0.0003 |
SELECT *
FROM `scores`
WHERE `type` = 'football'
AND `date` <= '2020-12-06'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0002 |
SELECT *
FROM `scores`
WHERE `type` = 'football2'
AND `date` <= '2020-12-06'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0002 |
SELECT *
FROM `scores`
WHERE `type` = 'football_f'
AND `date` <= '2020-12-06'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0002 |
SELECT *
FROM `scores`
WHERE `type` = 'basketball'
AND `date` <= '2020-12-06'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0002 |
SELECT *
FROM `scores`
WHERE `type` = 'basketball_f'
AND `date` <= '2020-12-06'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0002 |
SELECT *
FROM `scores`
WHERE `type` = 'rugby'
AND `date` <= '2020-12-06'
AND `score1` IS NOT NULL
AND `published` = 1
ORDER BY `date` DESC
LIMIT 1
|
| 0.0002 |
SELECT *
FROM `scores_rank`
WHERE `id` = 1
ORDER BY `id` ASC
|
| 0.0001 |
SELECT *
FROM `scores_rank`
WHERE `id` = 2
ORDER BY `id` ASC
|
