D:\phpStudy\MySQL\bin\mysqld.exe, Version: 5.5.53 (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument
319001 Quit
319002 Connect root@localhost on
319002 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319002 Init DB #mysql50#hjttwjc#
319002 Query SHOW TABLES LIKE 'xycms_address'
319002 Init DB #mysql50#hjttwjc#
319002 Query SHOW TABLE STATUS FROM `#mysql50#hjttwjc#` LIKE 'xycms\_address%'
319002 Query SELECT CURRENT_USER()
319002 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
319002 Query SHOW FULL COLUMNS
FROM `#mysql50#hjttwjc#`.`xycms_address`
319002 Quit
241022 11:44:00 319003 Connect root@localhost on
319003 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319003 Quit
241022 11:44:04 319004 Connect root@localhost on
319004 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319004 Init DB mysql
319004 Query SHOW MASTER LOGS
319004 Quit
241022 11:44:08 319005 Connect root@localhost on
319005 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319005 Quit
319006 Connect root@localhost on
319006 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319006 Query SET sql_mode=''
319006 Init DB ytvzx
241022 11:44:09 319006 Query SELECT * FROM xycms_config LIMIT 1
319006 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319006 Query SELECT * FROM xycms_region WHERE `en`='zhaoyuan'
319006 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319006 Query Select * From xycms_sp
319006 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319006 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='1' ORDER BY v.timeline DESC LIMIT 1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319006 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='2' ORDER BY v.orders DESC LIMIT 6
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 6
319007 Connect root@localhost on
319007 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319006 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319006 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.timeline DESC LIMIT 3
319006 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 8
319006 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 4
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319006 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.orders DESC LIMIT 6
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319006 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.orders DESC LIMIT 6
319007 Init DB mysql
319006 Query SELECT * FROM xycms_region where flag=1
319007 Query SHOW MASTER LOGS
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319006 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.orders DESC LIMIT 6
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319007 Quit
319006 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319006 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='7' ORDER BY v.orders DESC LIMIT 6
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319006 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='8' ORDER BY v.orders DESC LIMIT 6
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=9
319006 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='9' ORDER BY v.orders DESC LIMIT 6
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319006 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 3
319006 Query SELECT * FROM xycms_searchtype
319006 Query SELECT * FROM xycms_region ORDER BY orders ASC
319006 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319006 Query SELECT * FROM xycms_onlinechat WHERE flag=1
319006 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319006 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319006 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319006 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=13 AND v.flag=1 ORDER BY v.orders ASC
319006 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC
319006 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319008 Connect root@localhost on
319008 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='5' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='6' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='7' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='8' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='9' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='10' AND a.flag=1 ORDER BY a.orders ASC
319006 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319008 Query SHOW DATABASES
319006 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319006 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319006 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319006 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319008 Quit
319006 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319006 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319006 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319006 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319006 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319006 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319006 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319006 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=1
319006 Query SELECT * FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319006 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319006 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3
319006 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319006 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319006 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4
319006 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319006 Query SELECT cid FROM xycms_casecate WHERE parentid=1
319006 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=1
319006 Query SELECT * FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319006 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319006 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319006 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319006 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319006 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319006 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='2' LIMIT 10
319006 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='3' LIMIT 10
319006 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='4' LIMIT 10
319006 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5' LIMIT 10
319006 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='6' LIMIT 10
319006 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='7' LIMIT 10
319006 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='8' LIMIT 10
319006 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='9' LIMIT 10
319006 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319006 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=2
319006 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319006 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=3
319006 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319006 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=4
319006 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319006 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=5
319006 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=6
319006 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=6
319006 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319006 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=7
319006 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319006 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=8
319006 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=9
319006 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=9
319006 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query select cid from xycms_productcate where word='ytkdclb32'
319006 Query SELECT * FROM xycms_productcate where cid='6'
319006 Query SELECT cid FROM xycms_productcate WHERE parentid=6
319006 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='6'
319006 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='6' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 12
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query select * from xycms_productcate where cid ='6' LIMIT 1
319006 Query SELECT * FROM xycms_region where flag=1
319006 Query SELECT * FROM xycms_productcate WHERE cid='6' LIMIT 1
319006 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=6
319006 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=6
319006 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=6
319006 Query SELECT depth FROM xycms_productcate WHERE cid=6
319006 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319006 Query SELECT banner,parentid FROM xycms_productcate where cid=6
319006 Quit
241022 11:44:10 319009 Connect root@localhost on
319009 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319009 Quit
319010 Connect root@localhost on
319010 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319010 Quit
241022 11:44:11 319011 Connect root@localhost on
319011 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319011 Init DB mysql
319011 Query SHOW MASTER LOGS
319011 Query SELECT USER()
319011 Quit
319012 Connect root@localhost on
319012 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319012 Query SHOW DATABASES
319012 Quit
241022 11:44:17 319013 Connect root@localhost on
319013 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319013 Init DB mysql
319013 Query SHOW MASTER LOGS
319013 Quit
241022 11:44:18 319014 Connect root@localhost on
319014 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319014 Quit
241022 11:44:19 319015 Connect root@localhost on
319015 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319015 Init DB #mysql50#hjttwjc#
319015 Init DB #mysql50#hjttwjc#
319015 Query select @@datadir
319015 Query SHOW TABLE STATUS FROM `#mysql50#hjttwjc#` LIKE 'xycms\_address%'
319015 Query SELECT COUNT(*) FROM `#mysql50#hjttwjc#`.`xycms_address`
319015 Query SHOW CREATE TABLE `#mysql50#hjttwjc#`.`xycms_address`
319015 Quit
241022 11:44:21 319016 Connect root@localhost on
319016 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319016 Query SET GLOBAL general_log='on'
319016 Quit
241022 11:44:22 319017 Connect root@localhost on
319017 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319017 Quit
319018 Connect root@localhost on
319018 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319018 Init DB mysql
319018 Query SHOW MASTER LOGS
319018 Quit
319019 Connect root@localhost on
319019 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
241022 11:44:23 319019 Query SHOW DATABASES
319019 Quit
241022 11:44:28 319020 Connect root@localhost on
319020 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319020 Query SET sql_mode=''
319020 Init DB ytvzx
319020 Query SELECT * FROM xycms_config LIMIT 1
319020 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319020 Query SELECT * FROM xycms_region WHERE `en`='moupingqu'
319020 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319020 Query Select * From xycms_sp
319020 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319020 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='1' ORDER BY v.timeline DESC LIMIT 1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319020 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='2' ORDER BY v.orders DESC LIMIT 6
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 6
319020 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319020 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.timeline DESC LIMIT 3
319020 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 8
319020 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 4
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319020 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.orders DESC LIMIT 6
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319020 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.orders DESC LIMIT 6
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319020 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.orders DESC LIMIT 6
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319020 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='7' ORDER BY v.orders DESC LIMIT 6
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319020 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='8' ORDER BY v.orders DESC LIMIT 6
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=9
319020 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='9' ORDER BY v.orders DESC LIMIT 6
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319020 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 3
319020 Query SELECT * FROM xycms_searchtype
319020 Query SELECT * FROM xycms_region ORDER BY orders ASC
319020 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319020 Query SELECT * FROM xycms_onlinechat WHERE flag=1
319020 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319020 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319020 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319020 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=13 AND v.flag=1 ORDER BY v.orders ASC
319020 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC
319020 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='5' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='6' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='7' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='8' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='9' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='10' AND a.flag=1 ORDER BY a.orders ASC
319020 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319020 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319020 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319020 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319020 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319020 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319020 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319020 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319020 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319020 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319020 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319020 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319020 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=1
319020 Query SELECT * FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319020 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319020 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3
319020 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319020 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319020 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4
319020 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319020 Query SELECT cid FROM xycms_casecate WHERE parentid=1
319020 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=1
319020 Query SELECT * FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319020 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319020 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319020 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319020 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319020 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319020 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='2' LIMIT 10
319020 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='3' LIMIT 10
319020 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='4' LIMIT 10
319020 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5' LIMIT 10
319020 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='6' LIMIT 10
319020 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='7' LIMIT 10
319020 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='8' LIMIT 10
319020 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='9' LIMIT 10
319020 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319020 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=2
319020 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319020 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=3
319020 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319020 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=4
319020 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319020 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=5
319020 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=6
319020 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=6
319020 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319020 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=7
319020 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319020 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=8
319020 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT cid FROM xycms_productcate WHERE parentid=9
319020 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=9
319020 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.id='552'
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=3
319020 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319020 Query SELECT * FROM xycms_region ORDER BY orders ASC
319020 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319020 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%烟å°ä¸å¤®ç©ºè°ƒç³»ç»Ÿ%' or tag like '%烟å°ä¸å¤®ç©ºè°ƒ%' or tag like '%烟å°ä¸å¤®ç©ºè°ƒå“牌%') and `id` <> 552 ORDER BY timeline DESC limit 10
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_region where flag=1
319020 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%烟å°ä¸å¤®ç©ºè°ƒç³»ç»Ÿ%' or tag like '%烟å°ä¸å¤®ç©ºè°ƒ%' or tag like '%烟å°ä¸å¤®ç©ºè°ƒå“牌%' ORDER BY timeline DESC limit 10
319020 Query SELECT orders FROM xycms_product where id='552' and flag=1
319020 Query SELECT id,title,orders FROM xycms_product WHERE orders > 20 AND cid=(SELECT cid FROM xycms_product WHERE id = 552) AND front=1 ORDER BY orders DESC
319020 Query SELECT orders FROM xycms_product where id='552' and flag=1
319020 Query SELECT id,title,orders FROM xycms_product WHERE orders < 20 AND cid=(SELECT cid FROM xycms_product WHERE id = 552) AND front=1 ORDER BY orders DESC
319020 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=3
319020 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=3
319020 Query SELECT depth FROM xycms_productcate WHERE cid=3
319020 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319020 Query SELECT banner,parentid FROM xycms_productcate where cid=3
319020 Quit
319021 Connect root@localhost on
319021 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319021 Query Set global
general_log_file='D:\\phpStudy\\WWW\\test.php'
D:\phpStudy\MySQL\bin\mysqld.exe, Version: 5.5.53 (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument
319279 Quit
241022 12:00:36 319280 Connect root@localhost on
319280 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319280 Query SET sql_mode=''
319280 Init DB ycran
319280 Query SELECT * FROM xycms_config LIMIT 1
319280 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319280 Query SELECT * FROM xycms_region WHERE `en`='wuxi'
319280 Query Select * From xycms_sp
319280 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' ORDER BY v.timeline ASC LIMIT 6
319280 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' ORDER BY v.elite_orders DESC LIMIT 6
319280 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 6
319280 Query SELECT * FROM xycms_region WHERE `en`='wuxi'
319280 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319280 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319280 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319280 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=18 AND v.flag=1 ORDER BY v.orders ASC
319280 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=19 AND v.flag=1 ORDER BY v.orders ASC
319280 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319280 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319280 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319280 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319280 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319280 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='5' AND a.flag=1 ORDER BY a.orders ASC
319280 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='6' AND a.flag=1 ORDER BY a.orders ASC
319280 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='7' AND a.flag=1 ORDER BY a.orders ASC
319280 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='8' AND a.flag=1 ORDER BY a.orders ASC
319280 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319280 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319280 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319280 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319280 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319280 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319281 Connect root@localhost on
319281 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319281 Query SET sql_mode=''
319281 Init DB syzzrs
319281 Query SELECT * FROM xycms_config LIMIT 1
319281 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319281 Query SELECT * FROM xycms_region WHERE `en`='huadian'
319281 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319281 Query Select * From xycms_sp
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=45
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=48
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=49
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=50
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319281 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='1' OR v.cid=54 OR v.cid=45 OR v.cid=48 OR v.cid=49 OR v.cid=50 OR v.cid=51 OR v.cid=52 OR v.cid=53) ORDER BY v.timeline DESC LIMIT 6
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 3
319281 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' ORDER BY v.timeline DESC LIMIT 3
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=12
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=25
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=26
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319281 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='2' OR v.cid=12 OR v.cid=25 OR v.cid=26 OR v.cid=27 OR v.cid=28 OR v.cid=29) ORDER BY v.timeline DESC LIMIT 6
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=43
319281 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='3' OR v.cid=15 OR v.cid=43) ORDER BY v.timeline DESC LIMIT 6
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=19
319281 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='4' OR v.cid=19) ORDER BY v.timeline DESC LIMIT 6
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=20
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=21
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319281 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='20' OR v.cid=21 OR v.cid=60 OR v.cid=69) ORDER BY v.timeline DESC LIMIT 6
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=22
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=46
319281 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='22' OR v.cid=46) ORDER BY v.timeline DESC LIMIT 6
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=44
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=47
319281 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319281 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='44' OR v.cid=58 OR v.cid=57 OR v.cid=56 OR v.cid=55 OR v.cid=47 OR v.cid=59) ORDER BY v.timeline DESC LIMIT 6
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region
319281 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319281 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319281 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319281 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319281 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=13 AND v.flag=1 ORDER BY v.orders ASC
319281 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=14 AND v.flag=1 ORDER BY v.orders ASC
319281 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC
319281 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319281 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319281 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319281 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319281 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319281 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='5' AND a.flag=1 ORDER BY a.orders ASC
319281 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='6' AND a.flag=1 ORDER BY a.orders ASC
319281 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='7' AND a.flag=1 ORDER BY a.orders ASC
319281 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319281 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319281 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319281 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319281 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319281 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319281 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319280 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319281 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319280 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319281 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319280 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319281 Query SELECT c.* FROM xycms_infocate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319280 Query SELECT c.* FROM xycms_infocate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319281 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319281 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319281 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319281 Query SELECT c.* FROM xycms_casecate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319280 Query SELECT c.* FROM xycms_casecate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319281 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319281 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319280 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319281 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319280 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319281 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319280 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319281 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,parentid,word,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=11 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=24 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=10 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=25 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_productcate WHERE parentid=26 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query select cid from xycms_productcate where word='cpfllf78'
319281 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT cid FROM xycms_productcate WHERE parentid=9
319281 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='9'
319281 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='9' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 12
319281 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319281 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query select * from xycms_productcate where cid ='9' LIMIT 1
319281 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT * FROM xycms_productcate WHERE cid='9' LIMIT 1
319281 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=9
319281 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT depth FROM xycms_productcate WHERE cid=9
319281 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC
319280 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319281 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.id='768'
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=75
319281 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319282 Connect root@localhost on
319282 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319282 Query SET sql_mode=''
319282 Init DB syzzrs
319281 Query SELECT * FROM xycms_region
319281 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%休闲椅%' or tag like '%å°åŒºå…¬å›åº§æ¤…ä»·æ ¼%' or tag like '%å°åŒºå…¬å›åº§æ¤…批å‘%') and `id` <> 768 ORDER BY timeline DESC limit 10
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_region where flag=1
319281 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%休闲椅%' or tag like '%å°åŒºå…¬å›åº§æ¤…ä»·æ ¼%' or tag like '%å°åŒºå…¬å›åº§æ¤…批å‘%' ORDER BY timeline DESC limit 10
319281 Query SELECT orders FROM xycms_product where id='768' and flag=1
319281 Query SELECT id,title,orders FROM xycms_product WHERE orders > 569 AND cid=(SELECT cid FROM xycms_product WHERE id = 768) AND front=1 ORDER BY orders DESC
319281 Query SELECT orders FROM xycms_product where id='768' and flag=1
319281 Query SELECT id,title,orders FROM xycms_product WHERE orders < 569 AND cid=(SELECT cid FROM xycms_product WHERE id = 768) AND front=1 ORDER BY orders DESC
319281 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=75
319281 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=75
319281 Query SELECT depth FROM xycms_productcate WHERE cid=75
319281 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319280 Quit
319282 Query SELECT * FROM xycms_config LIMIT 1
319282 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319281 Quit
319282 Query SELECT * FROM xycms_region WHERE `en`='yining'
319282 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319282 Query Select * From xycms_sp
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=45
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=48
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=49
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=50
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319282 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='1' OR v.cid=54 OR v.cid=45 OR v.cid=48 OR v.cid=49 OR v.cid=50 OR v.cid=51 OR v.cid=52 OR v.cid=53) ORDER BY v.timeline DESC LIMIT 6
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 3
319282 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' ORDER BY v.timeline DESC LIMIT 3
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=12
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=25
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=26
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319282 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='2' OR v.cid=12 OR v.cid=25 OR v.cid=26 OR v.cid=27 OR v.cid=28 OR v.cid=29) ORDER BY v.timeline DESC LIMIT 6
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=43
319282 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='3' OR v.cid=15 OR v.cid=43) ORDER BY v.timeline DESC LIMIT 6
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=19
319282 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='4' OR v.cid=19) ORDER BY v.timeline DESC LIMIT 6
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=20
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=21
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319282 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='20' OR v.cid=21 OR v.cid=60 OR v.cid=69) ORDER BY v.timeline DESC LIMIT 6
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=22
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=46
319282 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='22' OR v.cid=46) ORDER BY v.timeline DESC LIMIT 6
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=44
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=47
319282 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319282 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='44' OR v.cid=58 OR v.cid=57 OR v.cid=56 OR v.cid=55 OR v.cid=47 OR v.cid=59) ORDER BY v.timeline DESC LIMIT 6
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region
319282 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319282 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319282 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319282 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319282 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=13 AND v.flag=1 ORDER BY v.orders ASC
319282 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=14 AND v.flag=1 ORDER BY v.orders ASC
319282 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC
319282 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319282 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319282 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319282 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319282 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319282 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='5' AND a.flag=1 ORDER BY a.orders ASC
319282 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='6' AND a.flag=1 ORDER BY a.orders ASC
319282 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='7' AND a.flag=1 ORDER BY a.orders ASC
319282 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319282 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319282 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319282 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319282 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319282 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319282 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319282 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319282 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319282 Query SELECT c.* FROM xycms_infocate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319282 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319282 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319282 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319282 Query SELECT c.* FROM xycms_casecate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319282 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319282 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319282 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319282 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319282 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC
319282 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.id='433'
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=51
319282 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319282 Query SELECT * FROM xycms_region
319282 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%   å°åŒºå¥èº«å™¨æ%' or tag like '%å°åŒºå¥èº«å™¨æä»·æ ¼%' or tag like '%å°åŒºå¥èº«å™¨æ批å‘%') and `id` <> 433 ORDER BY timeline DESC limit 10
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_region where flag=1
319282 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%   å°åŒºå¥èº«å™¨æ%' or tag like '%å°åŒºå¥èº«å™¨æä»·æ ¼%' or tag like '%å°åŒºå¥èº«å™¨æ批å‘%' ORDER BY timeline DESC limit 10
319282 Query SELECT orders FROM xycms_product where id='433' and flag=1
319282 Query SELECT id,title,orders FROM xycms_product WHERE orders > 234 AND cid=(SELECT cid FROM xycms_product WHERE id = 433) AND front=1 ORDER BY orders DESC
319282 Query SELECT orders FROM xycms_product where id='433' and flag=1
319282 Query SELECT id,title,orders FROM xycms_product WHERE orders < 234 AND cid=(SELECT cid FROM xycms_product WHERE id = 433) AND front=1 ORDER BY orders DESC
319282 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=51
319282 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=45
319282 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=1
319282 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=1
319282 Query SELECT depth FROM xycms_productcate WHERE cid=1
319282 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319282 Query SELECT depth FROM xycms_productcate WHERE cid=45
319282 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319282 Query SELECT depth FROM xycms_productcate WHERE cid=48
319282 Query SELECT depth FROM xycms_productcate WHERE cid=49
319282 Query SELECT depth FROM xycms_productcate WHERE cid=50
319282 Query SELECT depth FROM xycms_productcate WHERE cid=51
319282 Query SELECT depth FROM xycms_productcate WHERE cid=52
319282 Query SELECT depth FROM xycms_productcate WHERE cid=53
319282 Query SELECT depth FROM xycms_productcate WHERE cid=54
319282 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319282 Quit
241022 12:00:37 319283 Connect root@localhost on
319283 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319283 Query SET sql_mode=''
319283 Init DB qishunyun
319283 Query SELECT * FROM xycms_config LIMIT 1
319283 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319283 Query SELECT * FROM xycms_region WHERE `en`='guangdong'
319283 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319283 Query Select * From xycms_sp
319283 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319283 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.timeline DESC LIMIT 4
319283 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 6
319283 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319283 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 4
319283 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319283 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.orders DESC LIMIT 8
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319283 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='2' ORDER BY v.orders DESC LIMIT 8
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319283 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.orders DESC LIMIT 8
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319283 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.orders DESC LIMIT 8
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319283 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.orders DESC LIMIT 8
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT cid FROM xycms_productcate WHERE parentid=6
319283 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='6' ORDER BY v.orders DESC LIMIT 8
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319283 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='7' ORDER BY v.orders DESC LIMIT 8
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319283 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='8' ORDER BY v.orders DESC LIMIT 8
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319283 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4
319283 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 3
319283 Query SELECT * FROM xycms_region
319283 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319283 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319283 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319283 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319283 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=13 AND v.flag=1 ORDER BY v.orders ASC
319283 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC
319283 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=16 AND v.flag=1 ORDER BY v.orders ASC
319283 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='5' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='7' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='9' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='10' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='11' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='12' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='13' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='14' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='15' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='16' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='17' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='18' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='19' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='20' AND a.flag=1 ORDER BY a.orders ASC
319283 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319283 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319283 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319283 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319283 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319283 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319283 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319283 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319283 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319283 Query SELECT c.* FROM xycms_infocate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319283 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319283 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319283 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319283 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319283 Query SELECT c.* FROM xycms_casecate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319283 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319283 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319283 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319283 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319283 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319283 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=10 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query SELECT * FROM xycms_productcate WHERE parentid=11 AND flag=1 AND front=1 ORDER BY orders ASC
319283 Query select cid from xycms_productcate where word='qpsbf70'
319283 Query SELECT * FROM xycms_productcate where cid='1'
319283 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319283 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='1'
319283 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='1' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 18
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query select * from xycms_productcate where cid ='1' LIMIT 1
319283 Query SELECT * FROM xycms_region where flag=1
319283 Query SELECT * FROM xycms_productcate WHERE cid='1' LIMIT 1
319283 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=1
319283 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=1
319283 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=1
319283 Query SELECT depth FROM xycms_productcate WHERE cid=1
319283 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319283 Query SELECT banner,parentid FROM xycms_productcate where cid=1
319283 Quit
319284 Connect root@localhost on
319284 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319284 Query SET sql_mode=''
319284 Init DB 11_yizhou
319284 Query SELECT * FROM xycms_config LIMIT 1
319284 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319284 Query SELECT * FROM xycms_region WHERE `en`='gujiao'
319284 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319284 Query Select * From xycms_sp
319284 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319284 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 10
319284 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319284 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 10
319284 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 6
319284 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 10
319284 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319284 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 1
319284 Query SELECT * FROM xycms_translate
319284 Query SELECT * FROM xycms_region
319284 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319284 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319284 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319284 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319284 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319284 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319284 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319284 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319284 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319284 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319284 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319284 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319284 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319284 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319284 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319284 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319284 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319284 Query SELECT c.* FROM xycms_infocate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319284 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319284 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319284 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319284 Query SELECT c.* FROM xycms_casecate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319284 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319284 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319284 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319284 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319284 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319284 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319284 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319284 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319284 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319284 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319284 Query select cid from xycms_productcate where word='PVCzlsxcg90a'
319284 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319284 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='3'
319284 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='3' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 24
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query select * from xycms_productcate where cid ='3' LIMIT 1
319284 Query SELECT * FROM xycms_region where flag=1
319284 Query SELECT * FROM xycms_productcate WHERE cid='3' LIMIT 1
319284 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=3
319284 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=3
319284 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=3
319284 Query SELECT depth FROM xycms_productcate WHERE cid=3
319284 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319284 Query SELECT banner,parentid FROM xycms_productcate where cid=3
319284 Quit
241022 12:00:38 319285 Connect root@localhost on
319285 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319285 Query SET sql_mode=''
319285 Init DB zhengzhoupeng
319285 Query SELECT * FROM xycms_config LIMIT 1
319285 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319285 Query SELECT * FROM xycms_region WHERE `en`='beijing'
319285 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319285 Query Select * From xycms_sp
319285 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 4
319285 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 8
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319285 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 6
319285 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 6
319285 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319285 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319285 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4
319285 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319285 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 4
319285 Query SELECT * FROM xycms_region
319285 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319285 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319285 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319285 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319285 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=13 AND v.flag=1 ORDER BY v.orders ASC
319285 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319285 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319285 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319285 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319285 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319285 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='5' AND a.flag=1 ORDER BY a.orders ASC
319285 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319285 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319285 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319285 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319285 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319285 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319285 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319285 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319285 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319285 Query SELECT c.* FROM xycms_infocate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319285 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319285 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319285 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319285 Query SELECT c.* FROM xycms_casecate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319285 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319285 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319285 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319285 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319285 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319285 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319285 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319285 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319285 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319285 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319285 Query select cid from xycms_productcate where word='cpfly0c5'
319286 Connect root@localhost on
319285 Query SELECT * FROM xycms_productcate where cid='2'
319286 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319285 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319286 Query SET sql_mode=''
319285 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='2'
319286 Init DB qishunyun
319285 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='2' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 12
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query select * from xycms_productcate where cid ='2' LIMIT 1
319285 Query SELECT * FROM xycms_region where flag=1
319285 Query SELECT * FROM xycms_productcate WHERE cid='2' LIMIT 1
319285 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=2
319285 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=2
319285 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=2
319285 Query SELECT depth FROM xycms_productcate WHERE cid=2
319285 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319285 Query SELECT banner,parentid FROM xycms_productcate where cid=2
319286 Query SELECT * FROM xycms_config LIMIT 1
319286 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319285 Quit
319286 Query SELECT * FROM xycms_region WHERE `en`='yili'
319286 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319286 Query Select * From xycms_sp
319286 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319286 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.timeline DESC LIMIT 4
319286 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 6
319286 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319286 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 4
319286 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319286 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.orders DESC LIMIT 8
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319286 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='2' ORDER BY v.orders DESC LIMIT 8
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319286 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.orders DESC LIMIT 8
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319286 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.orders DESC LIMIT 8
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319286 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.orders DESC LIMIT 8
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT cid FROM xycms_productcate WHERE parentid=6
319286 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='6' ORDER BY v.orders DESC LIMIT 8
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319286 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='7' ORDER BY v.orders DESC LIMIT 8
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319286 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='8' ORDER BY v.orders DESC LIMIT 8
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319286 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4
319286 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 3
319286 Query SELECT * FROM xycms_region
319286 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319286 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319286 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319286 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319286 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=13 AND v.flag=1 ORDER BY v.orders ASC
319286 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC
319286 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=16 AND v.flag=1 ORDER BY v.orders ASC
319286 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
241022 12:00:39 319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='5' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='7' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='9' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='10' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='11' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='12' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='13' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='14' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='15' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='16' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='17' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='18' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='19' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='20' AND a.flag=1 ORDER BY a.orders ASC
319286 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319286 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319286 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319286 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319286 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319286 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319286 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319286 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319286 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319286 Query SELECT c.* FROM xycms_infocate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319286 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319286 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319286 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319286 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319286 Query SELECT c.* FROM xycms_casecate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319286 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319286 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319286 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319286 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319286 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319286 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=10 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query SELECT * FROM xycms_productcate WHERE parentid=11 AND flag=1 AND front=1 ORDER BY orders ASC
319286 Query select cid from xycms_productcate where word='rlsbc3b'
319286 Query SELECT * FROM xycms_productcate where cid='10'
319286 Query SELECT cid FROM xycms_productcate WHERE parentid=10
319286 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='10'
319286 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='10' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 18
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query select * from xycms_productcate where cid ='10' LIMIT 1
319286 Query SELECT * FROM xycms_region where flag=1
319286 Query SELECT * FROM xycms_productcate WHERE cid='10' LIMIT 1
319286 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=10
319286 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=10
319286 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=10
319286 Query SELECT depth FROM xycms_productcate WHERE cid=10
319286 Query SELECT * FROM xycms_productcate WHERE parentid=10 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319286 Query SELECT banner,parentid FROM xycms_productcate where cid=10
319286 Quit
319287 Connect root@localhost on
319287 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319287 Query SET sql_mode=''
319287 Init DB zhonghetiandi
319287 Query SELECT * FROM xycms_config LIMIT 1
319287 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319287 Query SELECT * FROM xycms_region WHERE `en`='tacheng'
319287 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319287 Query Select * From xycms_sp
319287 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 3
319287 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' ORDER BY v.orders DESC LIMIT 6
319287 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 6
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=13
319287 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='13' ORDER BY v.elite_orders DESC LIMIT 6
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319287 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='15' ORDER BY v.elite_orders DESC LIMIT 6
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=10
319287 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='10' ORDER BY v.elite_orders DESC LIMIT 6
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319287 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.elite_orders DESC LIMIT 6
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319287 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='8' ORDER BY v.elite_orders DESC LIMIT 6
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=11
319287 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='11' ORDER BY v.elite_orders DESC LIMIT 6
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319287 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='5' ORDER BY v.elite_orders DESC LIMIT 6
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT * FROM xycms_searchtype
319287 Query SELECT * FROM xycms_region ORDER BY orders ASC
319287 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319287 Query SELECT * FROM xycms_onlinechat WHERE flag=1
319287 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319287 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319287 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319287 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=13 AND v.flag=1 ORDER BY v.orders ASC
319287 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC
319287 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=16 AND v.flag=1 ORDER BY v.orders ASC
319287 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='6' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='7' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='8' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='9' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='10' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='11' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='12' AND a.flag=1 ORDER BY a.orders ASC
319287 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319287 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319287 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319287 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319287 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319287 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319287 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319287 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319287 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319287 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319287 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319287 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=1
319287 Query SELECT * FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319287 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3
319287 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319287 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4
319287 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_casecate WHERE parentid=11
319287 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=11
319287 Query SELECT * FROM xycms_casecate WHERE parentid=11 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_casecate WHERE parentid=9
319287 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=9
319287 Query SELECT * FROM xycms_casecate WHERE parentid=9 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_casecate WHERE parentid=10
319287 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=10
319287 Query SELECT * FROM xycms_casecate WHERE parentid=10 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_casecate WHERE parentid=2
319287 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=2
319287 Query SELECT * FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_casecate WHERE parentid=7
319287 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=7
319287 Query SELECT * FROM xycms_casecate WHERE parentid=7 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_casecate WHERE parentid=3
319287 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=3
319287 Query SELECT * FROM xycms_casecate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_casecate WHERE parentid=4
319287 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=4
319287 Query SELECT * FROM xycms_casecate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319287 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319287 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319287 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319287 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319287 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319287 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_productcate WHERE parentid=13 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_productcate WHERE parentid=10 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_productcate WHERE parentid=11 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='13' LIMIT 10
319287 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='15' LIMIT 10
319287 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='10' LIMIT 10
319287 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='3' LIMIT 10
319287 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='8' LIMIT 10
319287 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='11' LIMIT 10
319287 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5' LIMIT 10
319287 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=13
319287 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=13
319287 Query SELECT * FROM xycms_productcate WHERE parentid=13 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319287 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=15
319287 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=10
319287 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=10
319287 Query SELECT * FROM xycms_productcate WHERE parentid=10 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319287 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=3
319287 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319287 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=8
319287 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=11
319287 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=11
319287 Query SELECT * FROM xycms_productcate WHERE parentid=11 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_region where flag=1
319288 Connect root@localhost on
319287 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319288 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319287 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=5
319288 Query SET sql_mode=''
319288 Init DB lfxkhk
319287 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.id='559'
319287 Query SELECT * FROM xycms_region where flag=1
319287 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=5
319287 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319287 Query SELECT * FROM xycms_region ORDER BY orders ASC
319287 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319287 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%生æ€å›è®¾è®¡æ–¹æ¡ˆ%' or tag like '%生æ€å›%' or tag like '%生æ€å›è®¾è®¡%') and `id` <> 559 ORDER BY timeline DESC limit 10
319287 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%生æ€å›è®¾è®¡æ–¹æ¡ˆ%' or tag like '%生æ€å›%' or tag like '%生æ€å›è®¾è®¡%' ORDER BY timeline DESC limit 10
319288 Query SELECT * FROM xycms_config LIMIT 1
319288 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319287 Query SELECT orders FROM xycms_product where id='559' and flag=1
319287 Query SELECT id,title,orders FROM xycms_product WHERE orders > 27 AND cid=(SELECT cid FROM xycms_product WHERE id = 559) AND front=1 ORDER BY orders DESC
319287 Query SELECT orders FROM xycms_product where id='559' and flag=1
319287 Query SELECT id,title,orders FROM xycms_product WHERE orders < 27 AND cid=(SELECT cid FROM xycms_product WHERE id = 559) AND front=1 ORDER BY orders DESC
319287 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=5
319287 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=5
319287 Query SELECT depth FROM xycms_productcate WHERE cid=5
319287 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319287 Query SELECT banner,parentid FROM xycms_productcate where cid=5
319288 Query SELECT * FROM xycms_region WHERE `en`='meizhou'
319287 Quit
319288 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319288 Query Select * From xycms_sp
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 2
319288 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders ASC LIMIT 6
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 3
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 6
319288 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 5
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 5
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 5
319288 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 8
319288 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders ASC LIMIT 6
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 10
319288 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' ORDER BY v.elite_orders DESC LIMIT 6
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319288 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='27' ORDER BY v.orders DESC LIMIT 4
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319288 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='28' ORDER BY v.orders DESC LIMIT 4
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319288 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='29' ORDER BY v.orders DESC LIMIT 4
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 6
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 1
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 1
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319288 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 6
319288 Query SELECT * FROM xycms_searchtype
319288 Query SELECT * FROM xycms_region ORDER BY orders ASC
319288 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319288 Query SELECT * FROM xycms_onlinechat WHERE flag=1
319288 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319288 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319288 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319288 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=13 AND v.flag=1 ORDER BY v.orders ASC
319288 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC
319288 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='5' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='6' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='7' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='8' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='9' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='10' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='11' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='12' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='13' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='14' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='15' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='16' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='17' AND a.flag=1 ORDER BY a.orders ASC
319288 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319288 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319288 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319288 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319288 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319288 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319288 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319288 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319288 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319288 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319288 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319288 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3
319288 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319288 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4
319288 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319288 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319288 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=5
319288 Query SELECT * FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319288 Query SELECT cid FROM xycms_casecate WHERE parentid=1
319288 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=1
319288 Query SELECT * FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319288 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319288 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319288 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319288 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5'
319288 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319288 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5' LIMIT 10
319288 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319288 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=68 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='51' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='52' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='53' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='54' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='55' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='56' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='57' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='58' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='59' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='60' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='61' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='62' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='63' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='64' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='65' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='66' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='67' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='68' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='69' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='70' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='71' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='72' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='73' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='74' LIMIT 10
319288 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='75' LIMIT 10
319288 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=51
319288 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=52
319288 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=53
319288 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=54
319288 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=55
319288 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=56
319288 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=57
319288 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=58
319288 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=59
319288 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=60
319288 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=61
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=61
319288 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=62
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=62
319288 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=63
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=63
319288 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=64
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=64
319288 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=65
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=65
319288 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=66
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=66
319288 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=67
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=67
319288 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=68
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=68
319288 Query SELECT * FROM xycms_productcate WHERE parentid=68 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=69
319288 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=70
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=70
319288 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=71
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=71
319288 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=72
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=72
319288 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=73
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=73
319288 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=74
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=74
319288 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT cid FROM xycms_productcate WHERE parentid=75
319288 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=75
319288 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.id='1004'
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=32
319288 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319288 Query SELECT * FROM xycms_region ORDER BY orders ASC
319288 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319288 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%è¡ŒæŽæŽ¥åŒ…å°%' or tag like '%机场行æŽæŽ¥åŒ…å°%' or tag like '%%') and `id` <> 1004 ORDER BY timeline DESC limit 10
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_region where flag=1
319288 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%è¡ŒæŽæŽ¥åŒ…å°%' or tag like '%机场行æŽæŽ¥åŒ…å°%' or tag like '%%' ORDER BY timeline DESC limit 10
319288 Query SELECT orders FROM xycms_product where id='1004' and flag=1
319288 Query SELECT id,title,orders FROM xycms_product WHERE orders > 232 AND cid=(SELECT cid FROM xycms_product WHERE id = 1004) AND front=1 ORDER BY orders DESC
319288 Query SELECT orders FROM xycms_product where id='1004' and flag=1
319288 Query SELECT id,title,orders FROM xycms_product WHERE orders < 232 AND cid=(SELECT cid FROM xycms_product WHERE id = 1004) AND front=1 ORDER BY orders DESC
319288 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=32
319288 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=32
319288 Query SELECT depth FROM xycms_productcate WHERE cid=32
319288 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319288 Query SELECT banner,parentid FROM xycms_productcate where cid=32
319288 Quit
319289 Connect root@localhost on
319289 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319289 Query SET sql_mode=''
319289 Init DB 11_yizhou
319289 Query SELECT * FROM xycms_config LIMIT 1
319289 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319289 Query SELECT * FROM xycms_region WHERE `en`='jiangxi'
319289 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319289 Query Select * From xycms_sp
319289 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319289 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 10
319289 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319289 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 10
319289 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 6
319289 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 10
319289 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319289 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 1
319289 Query SELECT * FROM xycms_translate
319289 Query SELECT * FROM xycms_region
319289 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319289 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=1 AND v.flag=1 ORDER BY v.orders ASC
319289 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=9 AND v.flag=1 ORDER BY v.orders ASC
319289 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319289 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='1' AND a.flag=1 ORDER BY a.orders ASC
319289 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='2' AND a.flag=1 ORDER BY a.orders ASC
319289 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='3' AND a.flag=1 ORDER BY a.orders ASC
319289 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='4' AND a.flag=1 ORDER BY a.orders ASC
319289 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319289 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 AND c.front=1 ORDER BY c.orders ASC
319289 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319289 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
241022 12:00:40 319289 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319289 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders
319289 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir` != 'mobile' ORDER BY c.cid,v.orders
319289 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.orders ASC
319289 Query SELECT v.*,c.cname,c.img,c.target,c.linktype,c.linkurl FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC
319289 Query SELECT c.* FROM xycms_infocate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319289 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319289 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319289 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319289 Query SELECT c.* FROM xycms_casecate AS c WHERE c.parentid=0 AND c.flag=1 AND c.depth=0 ORDER BY c.orders ASC
319289 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319289 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319289 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319289 Query SELECT v.*,c.cname,c.target,c.linktype,c.linkurl FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 ORDER BY v.id DESC LIMIT 8
319289 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319289 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319289 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319289 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319289 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319289 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319289 Query select cid from xycms_productcate where word='PVCzlsxcg90a'
319289 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319289 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='3'
319289 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='3' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 24
319289 Query SELECT * FROM xycms_region where flag=1
319290 Connect root@localhost on
319290 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query select * from xycms_productcate where cid ='3' LIMIT 1
319289 Query SELECT * FROM xycms_region where flag=1
319289 Query SELECT * FROM xycms_productcate WHERE cid='3' LIMIT 1
319289 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=3
319289 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=3
319289 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=3
319289 Query SELECT depth FROM xycms_productcate WHERE cid=3
319289 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319289 Query SELECT banner,parentid FROM xycms_productcate where cid=3
319290 Query Set global
general_log_file='D:\\phpStudy\\WWW\\adadminmin.php'