| 0.0010 |
/*www.cnews.ru*/SELECT *
FROM (`book_pages`)
WHERE `slug` = 'Yoshino_Akira_-_Есино_Акира'
|
| 0.0007 |
/*www.cnews.ru*/SELECT COUNT(DISTINCT r.document_id) AS cnt
FROM (`book_pages_relevant_documents` r)
WHERE `r`.`page_id` = '213975'
AND NOT EXISTS (SELECT 1 FROM book_pages_documents pd WHERE pd.page_id = 213975 AND pd.document_id = r.document_id AND (pd.is_inactive=1 OR pd.category_id IS NOT NULL))
AND (r.title_keywords_count>0 OR r.keywords_count>4)
|
| 0.0008 |
/*www.cnews.ru*/SELECT COUNT(DISTINCT kd.document_id) AS cnt
FROM `book_keywords_documents` kd
INNER JOIN `book_pages_keywords` pk ON `pk`.`keyword_id`=`kd`.`keyword_id`
INNER JOIN `book_keywords` k ON `k`.`id`=`pk`.`keyword_id` AND (k.category_id <> 15 OR k.category_id IS NULL)
WHERE NOT EXISTS (SELECT 1 FROM book_pages_documents pd WHERE pd.page_id = '213975' AND pd.document_id = kd.document_id AND (pd.is_inactive=1 OR pd.category_id IS NOT NULL))
AND `pk`.`page_id` = '213975'
|
| 0.0005 |
/*www.cnews.ru*/SELECT *
FROM (`book_categories`)
WHERE `id` = '9'
|
| 0.0007 |
/*www.cnews.ru*/SELECT `c`.*
FROM (`book_categories` c)
WHERE `c`.`type` = 'page'
ORDER BY `c`.`position`
LIMIT 1000
|
| 0.0005 |
/*www.cnews.ru*/SELECT `c`.*
FROM (`book_categories` c)
WHERE `c`.`type` = 'document'
ORDER BY `c`.`position`
LIMIT 1000
|
| 0.1606 |
/*www.cnews.ru*/SELECT d.*, bpd.is_inactive FROM book_documents d LEFT JOIN book_pages_documents bpd ON bpd.page_id = 213975 AND bpd.document_id = d.id AND bpd.is_inactive=1 WHERE EXISTS (SELECT 1 FROM book_keywords_documents kd INNER JOIN book_pages_keywords pk ON pk.keyword_id=kd.keyword_id WHERE pk.page_id = 213975 and kd.document_id = d.id ) ORDER BY d.`date` DESC LIMIT 0, 40
|
| 0.0006 |
/*www.cnews.ru*/SELECT article_id AS publication_id, article_title AS title, article_translit AS translit, article_date AS pub_date
FROM (`articles` m)
WHERE `article_id` IN ('18139')
LIMIT 40
|
| 0.0006 |
/*www.cnews.ru*/SELECT COUNT(DISTINCT kd.document_id) AS cnt
FROM (`book_keywords_documents` kd)
INNER JOIN `book_pages_keywords` pk ON `pk`.`keyword_id`=`kd`.`keyword_id`
WHERE `pk`.`page_id` = '213975'
|
| 0.0011 |
/*www.cnews.ru*/WITH cte as (
SELECT kd.document_id, SUM(kd.count) AS keywords_count
FROM `book_keywords_documents` kd
INNER JOIN `book_pages_keywords` pk ON `pk`.`keyword_id`=`kd`.`keyword_id`
INNER JOIN `book_keywords` k ON `k`.`id`=`pk`.`keyword_id` AND (k.category_id <> 15 OR k.category_id IS NULL)
WHERE NOT EXISTS (SELECT 1 FROM book_pages_documents pd WHERE pd.page_id = '213975' AND pd.document_id = kd.document_id AND (pd.is_inactive=1 OR pd.category_id IS NOT NULL))
AND `pk`.`page_id` = '213975'
group by kd.document_id
)
select d.*, cte.keywords_count
from cte
INNER JOIN `book_documents` d ON cte.document_id = d.id
order by date desc
LIMIT 0, 40
|
| 0.0004 |
/*www.cnews.ru*/SELECT article_id AS publication_id, article_title AS title, article_translit AS translit, article_date AS pub_date
FROM (`articles` m)
WHERE `article_id` IN ('18139')
LIMIT 40
|
| 0.0018 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '1' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.2547 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='1' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0016 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '3' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.1673 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='3' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0016 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '43' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.0273 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='43' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0014 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '45' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.0188 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='45' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0022 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '5' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.0635 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='5' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0015 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '7' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.4237 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='7' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0018 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '9' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 1.2141 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='9' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0019 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '13' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.0520 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='13' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0017 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '17' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.0339 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='17' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0016 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '11' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.0241 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='11' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0043 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '37' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.0167 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='37' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0048 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '41' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.0509 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='41' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0042 |
/*www.cnews.ru*/WITH cte AS ( SELECT case when page1_id = '213975' then page2_id else page1_id end as page_id, mutual_documents_count FROM book_auto_pages_cache WHERE page1_id = '213975' or page2_id = '213975' ) SELECT p.id, p.slug, p.title, p.short_title_cache, p.documents_count_cache, cte.mutual_documents_count FROM cte INNER JOIN book_pages p ON cte.page_id = p.id WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id = '39' ORDER BY mutual_documents_count DESC LIMIT 0, 40
|
| 0.0196 |
/*www.cnews.ru*/SELECT COUNT(*) AS cnt FROM book_pages p FORCE INDEX(idx_bp_redirect_active_category_id)WHERE p.redirect_to_page_id IS NULL AND p.is_active = 1 AND p.category_id='39' and ( exists (SELECT 1 FROM book_auto_pages_cache WHERE page1_id = '213975' and page2_id = p.id) or exists (SELECT 1 FROM book_auto_pages_cache WHERE page2_id = '213975' and page1_id = p.id) )
|
| 0.0034 |
/*www.cnews.ru*/SELECT `l`.*
FROM (`book_links` l)
INNER JOIN `book_pages_links` pl ON `pl`.`link_id`=`l`.`id`
WHERE `pl`.`is_active` = '1'
AND `pl`.`page_id` = '213975'
|
| 0.0059 |
/*www.cnews.ru*/SELECT *
FROM (`randomizer`)
WHERE (randomizer_id=21611 OR randomizer_parent_id=21611)
ORDER BY `randomizer_order` ASC, `randomizer_text` ASC
|
| 0.0020 |
/*www.cnews.ru*/SELECT *
FROM (`randomizer`)
WHERE (randomizer_id=20551 OR randomizer_parent_id=20551)
ORDER BY `randomizer_order` ASC, `randomizer_text` ASC
|
| 0.0009 |
/*www.cnews.ru*/SELECT *
FROM (`randomizer`)
WHERE (randomizer_id=412 OR randomizer_parent_id=412)
ORDER BY `randomizer_order` ASC, `randomizer_text` ASC
|
Короткая ссылка
