| 0.0017 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `blog_categories`.`parent_id` =0
ORDER BY `name` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '29'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '32'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '28'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '3'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '23'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '4'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '102'
AND `category_id` IN('23', '4')
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '20'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '19'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '34'
AND `category_id` IN('20', '19')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '107'
AND `category_id` IN('20', '19')
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '24'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '25'
ORDER BY `id` ASC
|
| 0.0002 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '11'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '12'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '103'
AND `category_id` IN('11', '12')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '118'
AND `category_id` IN('11', '12')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '17'
|
| 0.0003 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '9'
AND `category_id` IN('11', '17')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '8'
AND `category_id` IN('11', '17')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '7'
AND `category_id` IN('11', '17')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '4'
AND `category_id` IN('11', '17')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '5'
AND `category_id` IN('11', '17')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '10'
AND `category_id` IN('11', '17')
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '33'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '18'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '31'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '7'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '26'
ORDER BY `id` ASC
|
| 0.0003 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '27'
ORDER BY `id` ASC
|
| 0.0002 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '22'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '13'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '39'
AND `category_id` IN('22', '13')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '82'
AND `category_id` IN('22', '13')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '97'
AND `category_id` IN('22', '13')
|
| 0.0003 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '46'
AND `category_id` IN('22', '13')
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '15'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '21'
ORDER BY `id` ASC
|
| 0.0002 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '36'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '37'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '214'
AND `category_id` IN('36', '37')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '226'
AND `category_id` IN('36', '37')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '38'
|
| 0.0001 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '34'
ORDER BY `id` ASC
|
| 0.0003 |
SELECT `id`, `name`, `slug`, (SELECT COUNT(blog_post_to_categories.id ) FROM blog_post_to_categories WHERE blog_post_to_categories.category_id = blog_categories.id) AS posts_count
FROM `blog_categories`
WHERE `parent_id` = '1'
ORDER BY `id` ASC
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '2'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '67'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '18'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '76'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '77'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '78'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '81'
AND `category_id` IN('1', '2')
|
| 0.0003 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '85'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '87'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '103'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '104'
AND `category_id` IN('1', '2')
|
| 0.0003 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '107'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '121'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '124'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '134'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '136'
AND `category_id` IN('1', '2')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '8'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '105'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '13'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '15'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '17'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '12'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '14'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '152'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '156'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '158'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '170'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '11'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '172'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '139'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '174'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '176'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '193'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '199'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '202'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '222'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '225'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '234'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '235'
AND `category_id` IN('1', '8')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '16'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '110'
AND `category_id` IN('1', '16')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '138'
AND `category_id` IN('1', '16')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '166'
AND `category_id` IN('1', '16')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '61'
AND `category_id` IN('1', '16')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '62'
AND `category_id` IN('1', '16')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '197'
AND `category_id` IN('1', '16')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '171'
AND `category_id` IN('1', '16')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '208'
AND `category_id` IN('1', '16')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '212'
AND `category_id` IN('1', '16')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '30'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '149'
AND `category_id` IN('1', '30')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '150'
AND `category_id` IN('1', '30')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '151'
AND `category_id` IN('1', '30')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `category_id` = '35'
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '208'
AND `category_id` IN('1', '35')
|
| 0.0001 |
SELECT `post_id`, `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '237'
AND `category_id` IN('1', '35')
|
| 0.0002 |
SELECT `blog_posts`.*, `blog_authors`.`name` as `author_name`
FROM `blog_posts`
LEFT JOIN `blog_authors` ON `blog_authors`.`id` = `blog_posts`.`author_id`
WHERE `blog_posts`.`id` IN('1602', '1606', '1607', '124')
|
| 0.0007 |
SELECT `blog_posts`.*, `blog_authors`.`name`
FROM `blog_posts`
JOIN `blog_post_to_categories` ON `blog_posts`.`id` = `blog_post_to_categories`.`post_id`
JOIN `blog_categories` ON `blog_post_to_categories`.`category_id` = `blog_categories`.`id`
JOIN `blog_authors` ON `blog_posts`.`author_id` = `blog_authors`.`id`
WHERE `blog_posts`.`status` = 'published'
AND `blog_categories`.`slug` = 'peripherals'
ORDER BY `blog_posts`.`sticky` DESC, `blog_posts`.`id` DESC
|
| 0.0001 |
SELECT `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '107'
|
| 0.0001 |
SELECT *
FROM `blog_categories`
WHERE `id` IN('2', '5', '19')
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `blog_comments`
WHERE `post_id` = '107'
AND `status` = '1'
|
| 0.0001 |
SELECT `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '34'
|
| 0.0001 |
SELECT *
FROM `blog_categories`
WHERE `id` IN('19')
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `blog_comments`
WHERE `post_id` = '34'
AND `status` = '1'
|
| 0.0005 |
SELECT `blog_posts`.*, `blog_authors`.`name`
FROM `blog_posts`
JOIN `blog_post_to_categories` ON `blog_posts`.`id` = `blog_post_to_categories`.`post_id`
JOIN `blog_categories` ON `blog_post_to_categories`.`category_id` = `blog_categories`.`id`
JOIN `blog_authors` ON `blog_posts`.`author_id` = `blog_authors`.`id`
WHERE `blog_posts`.`status` = 'published'
AND `blog_categories`.`slug` = 'peripherals'
ORDER BY `blog_posts`.`sticky` DESC, `blog_posts`.`id` DESC
LIMIT 10
|
| 0.0001 |
SELECT `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '107'
|
| 0.0003 |
SELECT *
FROM `blog_categories`
WHERE `id` IN('2', '5', '19')
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `blog_comments`
WHERE `post_id` = '107'
AND `status` = '1'
|
| 0.0001 |
SELECT `category_id`
FROM `blog_post_to_categories`
WHERE `post_id` = '34'
|
| 0.0001 |
SELECT *
FROM `blog_categories`
WHERE `id` IN('19')
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM `blog_comments`
WHERE `post_id` = '34'
AND `status` = '1'
|
| 0.0001 |
SELECT *
FROM `blog_comments`
WHERE `status` = 1
ORDER BY 1 DESC
LIMIT 5
|
| 0.0002 |
SELECT *
FROM `blog_posts`
WHERE `status` = 'published'
ORDER BY 1 DESC
LIMIT 5
|
| 0.0001 |
SELECT `blog_posts`.*, `blog_authors`.`name` as `author_name`
FROM `blog_posts`
LEFT JOIN `blog_authors` ON `blog_authors`.`id` = `blog_posts`.`author_id`
WHERE `blog_posts`.`id` IN('1602', '1606', '1607', '124')
|
