test

ProperAd.pl

Opublikowane:

22.11.2017

Podziel się:

0 min - średni czas potrzebny na przeczytanie artykułu

(default) 6 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Configuration`.`name`, `Configuration`.`value` FROM `properad_test`.`configurations` AS `Configuration` WHERE 1 = 1	11	11	0
2	SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`url`, `Article`.`active`, `Article`.`body_upper`, `Article`.`body`, `Article`.`banner_id`, `Article`.`lft`, `Article`.`rght`, `Article`.`parent_id`, `Article`.`keywords`, `Article`.`description`, `Article`.`created`, `Article`.`modified`, `Banner`.`id`, `Banner`.`title`, `Banner`.`body`, `Banner`.`url`, `Banner`.`name`, `Banner`.`alt`, `Banner`.`active`, `Banner`.`active_contests`, `Banner`.`active_events`, `Banner`.`active_articles`, `Banner`.`target`, `Banner`.`form`, `Banner`.`lft`, `Banner`.`rght`, `Banner`.`parent_id`, `Banner`.`lp_id`, `Banner`.`created`, `Banner`.`modified` FROM `properad_test`.`articles` AS `Article` LEFT JOIN `properad_test`.`banners` AS `Banner` ON (`Article`.`banner_id` = `Banner`.`id`) WHERE `Article`.`id` = 3 LIMIT 1	1	1	0
3	SELECT `ArticleAuthorsGroup`.`id`, `ArticleAuthorsGroup`.`article_id`, `ArticleAuthorsGroup`.`article_author_id`, `ArticleAuthorsGroup`.`lft`, `ArticleAuthorsGroup`.`rght`, `ArticleAuthorsGroup`.`parent_id` FROM `properad_test`.`article_authors_groups` AS `ArticleAuthorsGroup` WHERE `ArticleAuthorsGroup`.`article_id` = (3)	0	0	0
4	SELECT `ArticleCategoriesGroup`.`id`, `ArticleCategoriesGroup`.`article_id`, `ArticleCategoriesGroup`.`article_category_id`, `ArticleCategoriesGroup`.`lft`, `ArticleCategoriesGroup`.`rght`, `ArticleCategoriesGroup`.`parent_id` FROM `properad_test`.`article_categories_groups` AS `ArticleCategoriesGroup` WHERE `ArticleCategoriesGroup`.`article_id` = (3)	0	0	0
5	SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`body`, `Banner`.`url`, `Banner`.`name`, `Banner`.`alt`, `Banner`.`active`, `Banner`.`active_contests`, `Banner`.`active_events`, `Banner`.`active_articles`, `Banner`.`target`, `Banner`.`form`, `Banner`.`lft`, `Banner`.`rght`, `Banner`.`parent_id`, `Banner`.`lp_id`, `Banner`.`created`, `Banner`.`modified` FROM `properad_test`.`banners` AS `Banner` WHERE `Banner`.`id` IS NULL ORDER BY `lft` ASC, `id` DESC	0	0	0
6	SELECT `Ad`.`id`, `Ad`.`parent_id`, `Ad`.`lft`, `Ad`.`rght`, `Ad`.`title`, `Ad`.`body`, `Ad`.`position`, `Ad`.`width`, `Ad`.`height`, `Ad`.`order`, `Ad`.`active`, `Ad`.`created`, `Ad`.`modified` FROM `properad_test`.`ads` AS `Ad` WHERE `Ad`.`position` = 'front_home_top' AND `Ad`.`active` = 1	2	2	1

(default) 6 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Configuration`.`name`, `Configuration`.`value` FROM `properad_test`.`configurations` AS `Configuration` WHERE 1 = 1

SELECT `Article`.`id`, `Article`.`name`, `Article`.`title`, `Article`.`url`, `Article`.`active`, `Article`.`body_upper`, `Article`.`body`, `Article`.`banner_id`, `Article`.`lft`, `Article`.`rght`, `Article`.`parent_id`, `Article`.`keywords`, `Article`.`description`, `Article`.`created`, `Article`.`modified`, `Banner`.`id`, `Banner`.`title`, `Banner`.`body`, `Banner`.`url`, `Banner`.`name`, `Banner`.`alt`, `Banner`.`active`, `Banner`.`active_contests`, `Banner`.`active_events`, `Banner`.`active_articles`, `Banner`.`target`, `Banner`.`form`, `Banner`.`lft`, `Banner`.`rght`, `Banner`.`parent_id`, `Banner`.`lp_id`, `Banner`.`created`, `Banner`.`modified` FROM `properad_test`.`articles` AS `Article` LEFT JOIN `properad_test`.`banners` AS `Banner` ON (`Article`.`banner_id` = `Banner`.`id`) WHERE `Article`.`id` = 3 LIMIT 1

SELECT `ArticleAuthorsGroup`.`id`, `ArticleAuthorsGroup`.`article_id`, `ArticleAuthorsGroup`.`article_author_id`, `ArticleAuthorsGroup`.`lft`, `ArticleAuthorsGroup`.`rght`, `ArticleAuthorsGroup`.`parent_id` FROM `properad_test`.`article_authors_groups` AS `ArticleAuthorsGroup` WHERE `ArticleAuthorsGroup`.`article_id` = (3)

SELECT `ArticleCategoriesGroup`.`id`, `ArticleCategoriesGroup`.`article_id`, `ArticleCategoriesGroup`.`article_category_id`, `ArticleCategoriesGroup`.`lft`, `ArticleCategoriesGroup`.`rght`, `ArticleCategoriesGroup`.`parent_id` FROM `properad_test`.`article_categories_groups` AS `ArticleCategoriesGroup` WHERE `ArticleCategoriesGroup`.`article_id` = (3)

SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`body`, `Banner`.`url`, `Banner`.`name`, `Banner`.`alt`, `Banner`.`active`, `Banner`.`active_contests`, `Banner`.`active_events`, `Banner`.`active_articles`, `Banner`.`target`, `Banner`.`form`, `Banner`.`lft`, `Banner`.`rght`, `Banner`.`parent_id`, `Banner`.`lp_id`, `Banner`.`created`, `Banner`.`modified` FROM `properad_test`.`banners` AS `Banner` WHERE `Banner`.`id` IS NULL ORDER BY `lft` ASC, `id` DESC

SELECT `Ad`.`id`, `Ad`.`parent_id`, `Ad`.`lft`, `Ad`.`rght`, `Ad`.`title`, `Ad`.`body`, `Ad`.`position`, `Ad`.`width`, `Ad`.`height`, `Ad`.`order`, `Ad`.`active`, `Ad`.`created`, `Ad`.`modified` FROM `properad_test`.`ads` AS `Ad` WHERE `Ad`.`position` = 'front_home_top' AND `Ad`.`active` = 1