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

---