---

time: 0.390
memory: 1778432
templates: 5
query num: 33
query log:

SELECT COUNT(*) AS "count" FROM `CmsStat` WHERE `year`=YEAR(NOW()) AND `month`=MONTH(NOW()) AND `unique_list` LIKE "%38.107.179.229%"
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`="/fabrika/taiwan" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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`="29" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:09:05") 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:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:09:05") 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:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05") 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`="29" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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`="29" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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`="29" AND `t1`.`version`="0000-00-00 00:00:00" AND `t1`.`publish_time`<="2012-02-23 12:09:05" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:09:05") ORDER BY n DESC, create_time DESC
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:09:05" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:09:05") 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:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:09:05") 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:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:09:05") ORDER BY n DESC, create_time DESC
SELECT `image` FROM `CmsPage` AS A WHERE `id`="401" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
SELECT A.* FROM CmsPage A WHERE (''='' OR A.id IN (SELECT DISTINCT C.foreign_id FROM CmsAssoc C JOIN CmsAssoc D ON (C.id=D.id AND D.foreign_id=''))) AND (''='' OR A.id IN (SELECT DISTINCT C.foreign_id FROM CmsAssoc C JOIN CmsAssoc D ON (C.id=D.id AND D.foreign_id=''))) AND (''='' OR A.id IN (SELECT DISTINCT C.foreign_id FROM CmsAssoc C JOIN CmsAssoc D ON (C.id=D.id AND D.foreign_id=''))) AND A.parent_id=401 AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05") 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`="99" AND `A`.`version`="0000-00-00 00:00:00" AND `A`.`publish_time`<="2012-02-23 12:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`A`.`expire_time`="0000-00-00 00:00:00" OR `A`.`expire_time`>="2012-02-23 12:09:05")
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:09:05" AND (`t1`.`expire_time`="0000-00-00 00:00:00" OR `t1`.`expire_time`>="2012-02-23 12:09:05") ORDER BY n DESC, create_time DESC