| 0.0002 |
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` = '248148'
AND `published` != 10
AND `published` = 1
LIMIT 1
|
| 0.0004 |
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` = '248148'
LIMIT 1
|
| 0.0003 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248148'
LIMIT 50
|
| 0.0004 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248148'
AND `type` = 'article'
AND `approved` = 1
ORDER BY `created_at` DESC
|
| 0.0003 |
SELECT *
FROM `tag`
JOIN `tag_article` ON `id`=`tag_id`
WHERE `article_id` = '248148'
|
| 0.0004 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248148'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT *
FROM `menu`
WHERE `published` = 1
AND `published` != 10
AND `position` = 'main'
ORDER BY `parent_id` ASC, `hierarchy` ASC, `title` ASC
|
| 0.0014 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-05 07:43:49'
AND `published` = 1
AND `article_category`.`category_id` IN('3')
AND `on_home` = 1
AND `publication_date` >= '2020-11-25 07:43:49'
ORDER BY `hits` DESC
LIMIT 5
|
| 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` = '248335'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248335'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248335'
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` = '248335'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248335'
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` = '248342'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248342'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248342'
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` = '248342'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248342'
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` = '248344'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248344'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248344'
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` = '248344'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248344'
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` = '248355'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248355'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248355'
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` = '248355'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248355'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0012 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-05 07:43:49'
AND `published` = 1
AND `article_category`.`category_id` IN('7')
AND `on_home` = 1
AND `publication_date` >= '2020-11-25 07:43:49'
ORDER BY `hits` DESC
LIMIT 5
|
| 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` = '248343'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248343'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248343'
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` = '248343'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248343'
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` = '248346'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248346'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248346'
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` = '248346'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248346'
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` = '248349'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248349'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248349'
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` = '248349'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248349'
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` = '248351'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248351'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248351'
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` = '248351'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248351'
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` = '248353'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248353'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248353'
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` = '248353'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248353'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0006 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-05 07:43:49'
AND `published` = 1
AND `article_category`.`category_id` IN('9')
AND `on_home` = 1
AND `publication_date` >= '2020-11-25 07:43:49'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0006 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-05 07:43:49'
AND `published` = 1
AND `article_category`.`category_id` IN('42')
AND `on_home` = 1
AND `publication_date` >= '2020-11-25 07:43:49'
ORDER BY `hits` DESC
LIMIT 5
|
| 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` = '248345'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248345'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248345'
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` = '248345'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248345'
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` = '248346'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248346'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248346'
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` = '248346'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248346'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0005 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-05 07:43:49'
AND `published` = 1
AND `article_category`.`category_id` IN('8')
AND `on_home` = 1
AND `publication_date` >= '2020-11-25 07:43:49'
ORDER BY `hits` DESC
LIMIT 5
|
| 0.0005 |
SELECT `article`.*
FROM `article`
JOIN `article_category` ON `article`.`id`=`article_category`.`article_id`
WHERE `published` != 10
AND `publication_date` <= '2020-12-05 07:43:49'
AND `published` = 1
AND `article_category`.`category_id` IN('2')
AND `on_home` = 1
AND `publication_date` >= '2020-11-25 07:43:49'
ORDER BY `hits` DESC
LIMIT 5
|
| 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` = '248337'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248337'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248337'
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` = '248337'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248337'
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` = '248350'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248350'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248350'
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` = '248350'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248350'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 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.0001 |
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` = '247933'
AND `published` != 10
AND `published` = 1
LIMIT 1
|
| 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` = '247933'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '247933'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '247933'
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` = '247933'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '247933'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `type` = 'article'
AND `type_id` = '247933'
AND `approved` = 1
ORDER BY `created_at` ASC
|
| 0.0001 |
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` = '248078'
AND `published` != 10
AND `published` = 1
LIMIT 1
|
| 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` = '248078'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248078'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248078'
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` = '248078'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248078'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `type` = 'article'
AND `type_id` = '248078'
AND `approved` = 1
ORDER BY `created_at` ASC
|
| 0.0001 |
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` = '248128'
AND `published` != 10
AND `published` = 1
LIMIT 1
|
| 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` = '248128'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248128'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248128'
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` = '248128'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248128'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `type` = 'article'
AND `type_id` = '248128'
AND `approved` = 1
ORDER BY `created_at` ASC
|
| 0.0001 |
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` = '248104'
AND `published` != 10
AND `published` = 1
LIMIT 1
|
| 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` = '248104'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248104'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248104'
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` = '248104'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248104'
AND `published` = 1
ORDER BY `position` = 0, `position` ASC, `id` ASC
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `type` = 'article'
AND `type_id` = '248104'
AND `approved` = 1
ORDER BY `created_at` ASC
|
| 0.0005 |
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-05 07:43:49'
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` = '248358'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248358'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248358'
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` = '248358'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248358'
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` = '248357'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248357'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248357'
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` = '248357'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248357'
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` = '248356'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248356'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248356'
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` = '248356'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248356'
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` = '248355'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248355'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248355'
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` = '248355'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248355'
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` = '248354'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248354'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248354'
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` = '248354'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248354'
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` = '248353'
LIMIT 1
|
| 0.0001 |
SELECT `category_id`
FROM `article_category`
WHERE `default` = 0
AND `article_id` = '248353'
LIMIT 50
|
| 0.0001 |
SELECT *
FROM `users`
WHERE `id` = '4'
|
| 0.0001 |
SELECT *
FROM `comment`
WHERE `published` != 10
AND `text` != ''
AND `type_id` = '248353'
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` = '248353'
|
| 0.0001 |
SELECT *
FROM `article_file`
WHERE `article_id` = '248353'
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` = '05 Décembre'
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `saints`
WHERE `jour` = '5'
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-05'
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-05'
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-05'
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-05'
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-05'
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-05'
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
|
