---

time: 0.158
memory: 1737144
templates: 4
query num: 37
query log:

SELECT COUNT(*) AS "count" FROM `CmsStat` WHERE `year`=YEAR(NOW()) AND `month`=MONTH(NOW()) AND `unique_list` LIKE "%38.107.179.230%"
SELECT COUNT(*) AS "count" FROM `CmsStat` WHERE `year`=YEAR(NOW()) AND `month`=MONTH(NOW())
SELECT `id`,`link`,`version`,`parent_id`,`external_class`,`owner_id`,`title`,`create_time`,`publish_time`,`expire_time`,`n`,`childrens_template_src`,`cash`,`data_only`,`publish_time`,`use_content_in_head`,`template_src`,`childrens_template_src`,`head`,`keywords`,`description`,`content` FROM `CmsPage` AS A WHERE `link`="/tovar/shkaf_ps_2007" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT A.`title`,A.`id`,A.`link`,A.`version`,A.`parent_id`,A.`external_class`,A.`owner_id`,A.`create_time`,A.`publish_time`,A.`expire_time`,A.`n`,A.`childrens_template_src` FROM `CmsPage` AS A WHERE `id`="43" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT `id`,`link`,`version`,`parent_id`,`external_class`,`owner_id`,`title`,`create_time`,`publish_time`,`expire_time`,`n`,`childrens_template_src` FROM `CmsPage` AS A WHERE `id`="1" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT `description`,`image` FROM `CmsPage` AS A WHERE `id`="1" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT t1.`link`,t1.`title`,t1.`id`,t1.`version`,t1.`parent_id`,t1.`external_class`,t1.`owner_id`,t1.`create_time`,t1.`publish_time`,t1.`expire_time`,t1.`n`,t1.`childrens_template_src` FROM `CmsPage` AS t1 WHERE t1.`parent_id`="1" AND `t1`.`version`="0000-00-00 00:00:00" AND `t1`.`publish_time`<="2012-02-23 12:16:23" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:16:23") ORDER BY n DESC, create_time DESC
SELECT `id`,`link`,`version`,`parent_id`,`external_class`,`owner_id`,`title`,`create_time`,`publish_time`,`expire_time`,`n`,`childrens_template_src` FROM `CmsPage` AS A WHERE `id`="6" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT t1.`title`,t1.`id`,t1.`link`,t1.`version`,t1.`parent_id`,t1.`external_class`,t1.`owner_id`,t1.`create_time`,t1.`publish_time`,t1.`expire_time`,t1.`n`,t1.`childrens_template_src` FROM `CmsPage` AS t1 WHERE t1.`parent_id`="6" AND `t1`.`version`="0000-00-00 00:00:00" AND `t1`.`publish_time`<="2012-02-23 12:16:23" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:16:23") ORDER BY n DESC, create_time DESC
SELECT `id`,`link`,`version`,`parent_id`,`external_class`,`owner_id`,`title`,`create_time`,`publish_time`,`expire_time`,`n`,`childrens_template_src` FROM `CmsPage` AS A WHERE `id`="43" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT A.`title`,A.`image`,A.`id`,A.`link`,A.`version`,A.`parent_id`,A.`external_class`,A.`owner_id`,A.`create_time`,A.`publish_time`,A.`expire_time`,A.`n`,A.`childrens_template_src`,B.`cena` AS 'external.cena', "40" AS "assoc.foreign_id" FROM `CmsPage` AS A LEFT JOIN `tovar` AS B ON (A.id=B.id AND A.version=B.version) WHERE EXISTS (SELECT `id` FROM `CmsAssoc` WHERE `id`=`A`.`id` AND `foreign_id`="40") AND `parent_id`="43" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23") ORDER BY n DESC, create_time DESC
SELECT B.title AS 'kollekciya', C.title AS 'fabrika' FROM CmsAssoc AS A JOIN CmsPage AS B ON (A.foreign_id=B.id AND B.version='0000-00-00 00:00:00') JOIN CmsPage AS C ON (B.parent_id=C.id AND C.version='0000-00-00 00:00:00') WHERE A.id='565' AND C.parent_id=29
SELECT B.title AS 'kollekciya', C.title AS 'fabrika' FROM CmsAssoc AS A JOIN CmsPage AS B ON (A.foreign_id=B.id AND B.version='0000-00-00 00:00:00') JOIN CmsPage AS C ON (B.parent_id=C.id AND C.version='0000-00-00 00:00:00') WHERE A.id='521' AND C.parent_id=29
SELECT B.title AS 'kollekciya', C.title AS 'fabrika' FROM CmsAssoc AS A JOIN CmsPage AS B ON (A.foreign_id=B.id AND B.version='0000-00-00 00:00:00') JOIN CmsPage AS C ON (B.parent_id=C.id AND C.version='0000-00-00 00:00:00') WHERE A.id='484' AND C.parent_id=29
SELECT B.title AS 'kollekciya', C.title AS 'fabrika' FROM CmsAssoc AS A JOIN CmsPage AS B ON (A.foreign_id=B.id AND B.version='0000-00-00 00:00:00') JOIN CmsPage AS C ON (B.parent_id=C.id AND C.version='0000-00-00 00:00:00') WHERE A.id='453' AND C.parent_id=29
SELECT B.title AS 'kollekciya', C.title AS 'fabrika' FROM CmsAssoc AS A JOIN CmsPage AS B ON (A.foreign_id=B.id AND B.version='0000-00-00 00:00:00') JOIN CmsPage AS C ON (B.parent_id=C.id AND C.version='0000-00-00 00:00:00') WHERE A.id='447' AND C.parent_id=29
SELECT B.title AS 'kollekciya', C.title AS 'fabrika' FROM CmsAssoc AS A JOIN CmsPage AS B ON (A.foreign_id=B.id AND B.version='0000-00-00 00:00:00') JOIN CmsPage AS C ON (B.parent_id=C.id AND C.version='0000-00-00 00:00:00') WHERE A.id='205' AND C.parent_id=29
SELECT B.title AS 'kollekciya', C.title AS 'fabrika' FROM CmsAssoc AS A JOIN CmsPage AS B ON (A.foreign_id=B.id AND B.version='0000-00-00 00:00:00') JOIN CmsPage AS C ON (B.parent_id=C.id AND C.version='0000-00-00 00:00:00') WHERE A.id='380' AND C.parent_id=29
SELECT B.title AS 'kollekciya', C.title AS 'fabrika' FROM CmsAssoc AS A JOIN CmsPage AS B ON (A.foreign_id=B.id AND B.version='0000-00-00 00:00:00') JOIN CmsPage AS C ON (B.parent_id=C.id AND C.version='0000-00-00 00:00:00') WHERE A.id='201' AND C.parent_id=29
SELECT `parent_id`, `childrens_template_src` FROM `CmsPage` AS A WHERE `id`="43" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT t1.`id`,t1.`title`,t1.`link`,t1.`version`,t1.`parent_id`,t1.`external_class`,t1.`owner_id`,t1.`create_time`,t1.`publish_time`,t1.`expire_time`,t1.`n`,t1.`childrens_template_src` FROM `CmsPage` AS t1 WHERE t1.`parent_id`="6" AND `t1`.`version`="0000-00-00 00:00:00" AND `t1`.`publish_time`<="2012-02-23 12:16:23" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:16:23") ORDER BY n DESC, create_time DESC
SELECT `id`,`link`,`version`,`parent_id`,`external_class`,`owner_id`,`title`,`create_time`,`publish_time`,`expire_time`,`n`,`childrens_template_src` FROM `CmsPage` AS A WHERE `id`="14" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT t1.`id`,t1.`title`,t1.`link`,t1.`version`,t1.`parent_id`,t1.`external_class`,t1.`owner_id`,t1.`create_time`,t1.`publish_time`,t1.`expire_time`,t1.`n`,t1.`childrens_template_src` FROM `CmsPage` AS t1 WHERE t1.`parent_id`="14" AND `t1`.`version`="0000-00-00 00:00:00" AND `t1`.`publish_time`<="2012-02-23 12:16:23" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:16:23") ORDER BY n DESC, create_time DESC
SELECT `id`,`link`,`version`,`parent_id`,`external_class`,`owner_id`,`title`,`create_time`,`publish_time`,`expire_time`,`n`,`childrens_template_src` FROM `CmsPage` AS A WHERE `id`="24" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT t1.`description`,t1.`title`,t1.`id`,t1.`link`,t1.`version`,t1.`parent_id`,t1.`external_class`,t1.`owner_id`,t1.`create_time`,t1.`publish_time`,t1.`expire_time`,t1.`n`,t1.`childrens_template_src` FROM `CmsPage` AS t1 WHERE t1.`parent_id`="24" AND `t1`.`version`="0000-00-00 00:00:00" AND `t1`.`publish_time`<="2012-02-23 12:16:23" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:16:23") ORDER BY n DESC, create_time DESC
SELECT `id`,`link`,`version`,`parent_id`,`external_class`,`owner_id`,`title`,`create_time`,`publish_time`,`expire_time`,`n`,`childrens_template_src` FROM `CmsPage` AS A WHERE `id`="20" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT t1.`id`,t1.`title`,t1.`link`,t1.`version`,t1.`parent_id`,t1.`external_class`,t1.`owner_id`,t1.`create_time`,t1.`publish_time`,t1.`expire_time`,t1.`n`,t1.`childrens_template_src` FROM `CmsPage` AS t1 WHERE t1.`parent_id`="20" AND `t1`.`version`="0000-00-00 00:00:00" AND `t1`.`publish_time`<="2012-02-23 12:16:23" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:16:23") ORDER BY n DESC, create_time DESC
SELECT `image`,`id`,`version`,`parent_id` FROM `CmsPage` AS A WHERE `id`="412" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT `external_class` FROM `CmsPage` AS A WHERE `id`="43" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT `cena` FROM `tovar` AS A WHERE `id`="412" AND `version`="0000-00-00 00:00:00"
SELECT B.title AS 'kollekciya', B.link AS 'kollekciya_link', C.title AS 'fabrika', C.link AS 'fabrika_link' FROM CmsAssoc AS A JOIN CmsPage AS B ON (A.foreign_id=B.id AND B.version='0000-00-00 00:00:00') JOIN CmsPage AS C ON (B.parent_id=C.id AND C.version='0000-00-00 00:00:00') WHERE A.id='412' AND C.parent_id=29
SELECT COUNT(*) AS "count" FROM CmsPage AS A NATURAL JOIN tovar JOIN CmsAssoc ON (A.id=CmsAssoc.id) WHERE CmsAssoc.foreign_id='412' AND `A`.`version` IN (SELECT MAX(`version`) FROM `CmsPage` WHERE `id`=`A`.`id`)
SELECT A.*, tovar.cena AS 'external.cena' FROM CmsPage AS A NATURAL JOIN tovar JOIN CmsAssoc ON (A.id=CmsAssoc.id) WHERE CmsAssoc.foreign_id='412' AND `A`.`version` IN (SELECT MAX(`version`) FROM `CmsPage` WHERE `id`=`A`.`id`) ORDER BY `n` DESC, `create_time` DESC LIMIT 0, 10
SELECT `id`,`link`,`version`,`parent_id`,`external_class`,`owner_id`,`title`,`create_time`,`publish_time`,`expire_time`,`n`,`childrens_template_src` FROM `CmsPage` AS A WHERE `id`="99" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT `description` FROM `CmsPage` AS A WHERE `id`="99" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT `id`,`link`,`version`,`parent_id`,`external_class`,`owner_id`,`title`,`create_time`,`publish_time`,`expire_time`,`n`,`childrens_template_src` FROM `CmsPage` AS A WHERE `id`="41" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:16:23" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:16:23")
SELECT t1.`title`,t1.`id`,t1.`link`,t1.`version`,t1.`parent_id`,t1.`external_class`,t1.`owner_id`,t1.`create_time`,t1.`publish_time`,t1.`expire_time`,t1.`n`,t1.`childrens_template_src` FROM `CmsPage` AS t1 WHERE t1.`parent_id`="41" AND `t1`.`version`="0000-00-00 00:00:00" AND `t1`.`publish_time`<="2012-02-23 12:16:23" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:16:23") ORDER BY n DESC, create_time DESC