Input
$_POST : Array
(
[page_id] => 1
[parentBlock] => 0
[currentBlock] => 5
[systemOutput] => on
[start] => 0
[limit] => 20
[dir] => DESC
[sort] => votes
[search] =>
)
$_SESSION : Array
(
[lastPageId] => 1
)
Queries : Array
(
[0] => SET NAMES UTF8
[1] => SELECT * FROM page_list WHERE defaultVisitor=1
[2] => SELECT _resourcesAccess.* FROM _resources LEFT JOIN _resourcesAccess ON _resources.id = _resourcesAccess.resourceId WHERE _resources.module = 'page' AND _resources.controller = 'default' AND _resources.method = 'index' AND _resources.params = ''
[3] => SELECT page_columns.* FROM `page_list` INNER JOIN `page_columns` ON `page_list`.`id`=`page_columns`.`pageId` WHERE `pageId`=1 ORDER BY page_columns.position ASC
[4] => SELECT page_columnsContents.* FROM `page_columnsContents` WHERE `columnId`=1 ORDER BY position
[5] => SELECT * FROM `page_blocks` WHERE `id`=9
[6] => SELECT * FROM `page_blocksParameters` INNER JOIN `page_columnsBlocksParameters` ON `page_columnsBlocksParameters`.`blockParameterId`= `page_blocksParameters`.`id` WHERE `blockId`=9 AND page_columnsBlocksParameters.columnsContentId=17 ORDER BY position ASC
[7] => SELECT * FROM page_list WHERE defaultVisitor=1
[8] => SELECT * FROM page_list WHERE parentId = 0 AND isTemplate='0' AND inMenu = 1 ORDER BY position ASC
[9] => SELECT * FROM page_list WHERE parentId = 1 AND isTemplate='0' AND inMenu = 1 ORDER BY position ASC
[10] => SELECT * FROM page_list WHERE parentId = 53 AND isTemplate='0' AND inMenu = 1 ORDER BY position ASC
[11] => SELECT * FROM `page_blocks` WHERE `id`=7
[12] => SELECT * FROM `page_blocksParameters` INNER JOIN `page_columnsBlocksParameters` ON `page_columnsBlocksParameters`.`blockParameterId`= `page_blocksParameters`.`id` WHERE `blockId`=7 AND page_columnsBlocksParameters.columnsContentId=8 ORDER BY position ASC
[13] => SELECT * FROM _languages
[14] => SELECT COUNT(*) as cnt FROM (((`ads` INNER JOIN `_languagesTexts` ON `ads`.`title` = `_languagesTexts`.`id` ) INNER JOIN `_languagesTexts` textDescription ON textDescription.id=`ads`.`description` ) INNER JOIN adsCategories ON adsCategories.id=ads.categoryId) INNER JOIN `_languagesTexts` category ON category.id=`adsCategories`.`name` WHERE `_languagesTexts`.`textFr`!='' AND `_languagesTexts`.`textFr`!=''
[15] => SELECT `ads`.*,`_languagesTexts`.`textFr` as title,`textDescription`.`textFr` as description,`category`.`textFr` as category FROM (((`ads` INNER JOIN `_languagesTexts` ON `ads`.`title` = `_languagesTexts`.`id` ) INNER JOIN `_languagesTexts` textDescription ON textDescription.id=`ads`.`description` ) INNER JOIN adsCategories ON adsCategories.id=ads.categoryId) INNER JOIN `_languagesTexts` category ON category.id=`adsCategories`.`name`WHERE `_languagesTexts`.`textFr`!='' AND `_languagesTexts`.`textFr`!='' ORDER BY ads.date DESC LIMIT 0, 10
[16] => SELECT * FROM page_list WHERE id=51
[17] => SELECT page_columnsContents.* FROM `page_columnsContents` WHERE `columnId`=2 ORDER BY position
[18] => SELECT * FROM `page_html` WHERE `id`=1
[19] => SELECT * FROM `page_blocks` WHERE `id`=4
[20] => SELECT * FROM `page_blocksParameters` INNER JOIN `page_columnsBlocksParameters` ON `page_columnsBlocksParameters`.`blockParameterId`= `page_blocksParameters`.`id` WHERE `blockId`=4 AND page_columnsBlocksParameters.columnsContentId=3 ORDER BY position ASC
[21] => SELECT COUNT(*) as cnt FROM `adsCategories` INNER JOIN `_languagesTexts` ON `adsCategories`.`name` = `_languagesTexts`.`id`
[22] => SELECT `adsCategories`.*,`textFr` as catname FROM `adsCategories` INNER JOIN `_languagesTexts` ON `adsCategories`.`name` = `_languagesTexts`.`id`
[23] => SELECT * FROM page_list WHERE id=43
[24] => SELECT * FROM `page_html` WHERE `id`=3
[25] => SELECT * FROM `page_blocks` WHERE `id`=5
[26] => SELECT * FROM `page_blocksParameters` INNER JOIN `page_columnsBlocksParameters` ON `page_columnsBlocksParameters`.`blockParameterId`= `page_blocksParameters`.`id` WHERE `blockId`=5 AND page_columnsBlocksParameters.columnsContentId=6 ORDER BY position ASC
[27] => SELECT * FROM _languages
[28] => SELECT COUNT(*) as cnt FROM (((`ads` INNER JOIN `_languagesTexts` ON `ads`.`title` = `_languagesTexts`.`id` ) INNER JOIN `_languagesTexts` textDescription ON textDescription.id=`ads`.`description` ) INNER JOIN adsCategories ON adsCategories.id=ads.categoryId) INNER JOIN `_languagesTexts` category ON category.id=`adsCategories`.`name` WHERE `_languagesTexts`.`textFr`!='' AND `_languagesTexts`.`textFr`!=''
[29] => SELECT `ads`.*,`_languagesTexts`.`textFr` as title,`textDescription`.`textFr` as description,`category`.`textFr` as category FROM (((`ads` INNER JOIN `_languagesTexts` ON `ads`.`title` = `_languagesTexts`.`id` ) INNER JOIN `_languagesTexts` textDescription ON textDescription.id=`ads`.`description` ) INNER JOIN adsCategories ON adsCategories.id=ads.categoryId) INNER JOIN `_languagesTexts` category ON category.id=`adsCategories`.`name`WHERE `_languagesTexts`.`textFr`!='' AND `_languagesTexts`.`textFr`!='' ORDER BY ads.votes DESC LIMIT 0, 10
[30] => SELECT * FROM page_list WHERE id=51
[31] => SELECT page_columnsContents.* FROM `page_columnsContents` WHERE `columnId`=3 ORDER BY position
[32] => SELECT * FROM `page_html` WHERE `id`=2
[33] => SELECT * FROM `page_blocks` WHERE `id`=5
[34] => SELECT * FROM `page_blocksParameters` INNER JOIN `page_columnsBlocksParameters` ON `page_columnsBlocksParameters`.`blockParameterId`= `page_blocksParameters`.`id` WHERE `blockId`=5 AND page_columnsBlocksParameters.columnsContentId=5 ORDER BY position ASC
[35] => SELECT * FROM _languages
[36] => SELECT COUNT(*) as cnt FROM (((`ads` INNER JOIN `_languagesTexts` ON `ads`.`title` = `_languagesTexts`.`id` ) INNER JOIN `_languagesTexts` textDescription ON textDescription.id=`ads`.`description` ) INNER JOIN adsCategories ON adsCategories.id=ads.categoryId) INNER JOIN `_languagesTexts` category ON category.id=`adsCategories`.`name` WHERE `_languagesTexts`.`textFr`!='' AND `_languagesTexts`.`textFr`!=''
[37] => SELECT `ads`.*,`_languagesTexts`.`textFr` as title,`textDescription`.`textFr` as description,`category`.`textFr` as category FROM (((`ads` INNER JOIN `_languagesTexts` ON `ads`.`title` = `_languagesTexts`.`id` ) INNER JOIN `_languagesTexts` textDescription ON textDescription.id=`ads`.`description` ) INNER JOIN adsCategories ON adsCategories.id=ads.categoryId) INNER JOIN `_languagesTexts` category ON category.id=`adsCategories`.`name`WHERE `_languagesTexts`.`textFr`!='' AND `_languagesTexts`.`textFr`!='' ORDER BY ads.votes DESC LIMIT 0, 20
[38] => SELECT * FROM page_list WHERE id=51
)
Performance
Execution took: 0.039399 seconds