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
261003 21:33:36 4362704 Init DB mysql
4362703 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
4362703 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
4362703 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
4362703 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
4362703 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
4362703 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
4362703 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
4362703 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
4362703 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
4362703 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
4362703 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
4362703 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
4362703 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
4362703 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
4362703 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
4362703 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
4362703 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
4362703 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
4362704 Query SHOW TABLES FROM `mysql`
4362704 Query SHOW TABLE STATUS FROM `mysql`
4362704 Query SELECT CURRENT_USER()
4362704 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT'
4362704 Query SELECT CURRENT_USER()
4362704 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
4362704 Quit
4362703 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
4362703 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
4362703 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
4362703 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
4362703 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
4362703 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
4362703 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
4362703 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
4362703 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
4362703 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
4362703 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
4362703 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
4362703 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
4362703 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
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC
4362703 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 in (282,283,281,284,293) ORDER BY v.orders DESC
4362703 Query SELECT * FROM xycms_region where flag=1
4362703 Query SELECT * FROM xycms_region where flag=1
4362703 Query SELECT * FROM xycms_region where flag=1
4362703 Query SELECT * FROM xycms_region where flag=1
4362703 Query SELECT * FROM xycms_region where flag=1
4362703 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='281'
4362703 Query SELECT * FROM xycms_region where flag=1
4362703 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=57
4362703 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
4362703 Query SELECT * FROM xycms_region
4362703 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '% 秋千、跷跷板、摇乐%' or tag like '%秋千价格%' or tag like '%秋千批发%') and `id` <> 281 ORDER BY timeline DESC limit 10
4362703 Query SELECT * FROM xycms_region where flag=1
4362703 Query SELECT * FROM xycms_region where flag=1
4362703 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '% 秋千、跷跷板、摇乐%' or tag like '%秋千价格%' or tag like '%秋千批发%' ORDER BY timeline DESC limit 10
4362703 Query SELECT orders FROM xycms_product where id='281' and flag=1
4362703 Query SELECT id,title,orders FROM xycms_product WHERE orders > 82 AND cid=(SELECT cid FROM xycms_product WHERE id = 281) AND front=1 ORDER BY orders DESC
4362703 Query SELECT orders FROM xycms_product where id='281' and flag=1
4362703 Query SELECT id,title,orders FROM xycms_product WHERE orders < 82 AND cid=(SELECT cid FROM xycms_product WHERE id = 281) AND front=1 ORDER BY orders DESC
4362703 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=57
4362703 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=44
4362703 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=44
4362703 Query SELECT depth FROM xycms_productcate WHERE cid=44
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders,cid DESC
4362703 Query SELECT depth FROM xycms_productcate WHERE cid=47
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders,cid DESC
4362703 Query SELECT depth FROM xycms_productcate WHERE cid=55
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders,cid DESC
4362703 Query SELECT depth FROM xycms_productcate WHERE cid=56
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders,cid DESC
4362703 Query SELECT depth FROM xycms_productcate WHERE cid=57
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders,cid DESC
4362703 Query SELECT depth FROM xycms_productcate WHERE cid=58
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders,cid DESC
4362703 Query SELECT depth FROM xycms_productcate WHERE cid=59
4362703 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders,cid DESC
4362703 Quit
4362705 Connect root@localhost on
4362705 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
4362705 Init DB mysql
4362705 Init DB mysql
4362705 Query SELECT '
Warning: system() [function.system]: Cannot execute a blank command in D:\phpStudy\WWW\log_x.php on line 111
' AS a
4362705 Init DB mysql
4362705 Query SHOW TABLES FROM `mysql`
4362705 Query SHOW TABLE STATUS FROM `mysql`
4362705 Query SELECT CURRENT_USER()
4362705 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT'
4362705 Query SELECT CURRENT_USER()
4362705 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
4362705 Query SHOW VARIABLES LIKE 'profiling'
4362705 Query SHOW TABLES
4362705 Quit
261003 21:33:37 4362706 Connect root@localhost on
4362706 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
4362706 Query SET sql_mode=''
4362706 Init DB zjrymy
4362706 Query SELECT * FROM xycms_config LIMIT 1
4362706 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
4362706 Query SELECT * FROM xycms_region WHERE `en`='eerduosi'
4362706 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
4362706 Query Select * From xycms_sp
4362706 Query SELECT * FROM xycms_searchtype
4362706 Query SELECT * FROM xycms_region ORDER BY orders ASC
4362706 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
4362706 Query SELECT * FROM xycms_onlinechat WHERE flag=1
4362706 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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
4362706 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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
4362706 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
4362706 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
4362706 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
4362706 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
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
4362706 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
4362706 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
4362706 Query SELECT v.* FROM xycms_brand AS v WHERE v.flag=1 ORDER BY v.orders ASC
4362706 Query SELECT v.* FROM xycms_brand AS v WHERE v.flag=1 ORDER BY v.orders ASC
4362706 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
4362706 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
4362706 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
4362706 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
4362706 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_infocate WHERE parentid=1
4362706 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=1
4362706 Query SELECT * FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_infocate WHERE parentid=3
4362706 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3
4362706 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_infocate WHERE parentid=4
4362706 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4
4362706 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT v.*,c.cname FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='1' LIMIT 10
4362706 Query SELECT v.*,c.cname FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='3' LIMIT 10
4362706 Query SELECT v.*,c.cname FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='4' LIMIT 10
4362706 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_casecate WHERE parentid=1
4362706 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=1
4362706 Query SELECT * FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_casecate WHERE parentid=2
4362706 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=2
4362706 Query SELECT * FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_casecate WHERE parentid=3
4362706 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=3
4362706 Query SELECT * FROM xycms_casecate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_casecate WHERE parentid=4
4362706 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=4
4362706 Query SELECT * FROM xycms_casecate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_casecate WHERE parentid=5
4362706 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=5
4362706 Query SELECT * FROM xycms_casecate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_casecate WHERE parentid=6
4362706 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=6
4362706 Query SELECT * FROM xycms_casecate WHERE parentid=6 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_albumcate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
4362706 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
4362706 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
4362706 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
4362706 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
4362706 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
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 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
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=16 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=17 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=18 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 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='1' LIMIT 10
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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
4362706 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='16' LIMIT 10
4362706 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='17' LIMIT 10
4362706 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='18' LIMIT 10
4362706 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='19' LIMIT 10
4362706 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='20' LIMIT 10
4362706 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='21' LIMIT 10
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=1
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=1
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=2
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=2
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=3
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=3
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=4
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=4
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=5
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=5
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=8
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=9
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=10
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=11
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=12
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=13
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=14
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND (cid=8 OR cid=9 OR cid=10 OR cid=11 OR cid=12 OR cid=13 OR cid=14)
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=9
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=10
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=11
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=12
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=13
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=14
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND (cid=9 OR cid=10 OR cid=11 OR cid=12 OR cid=13 OR cid=14)
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=7
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=7
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=6
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=6
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=15
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=15
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=16
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=16
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=16 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=17
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=17
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=17 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=18
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=18
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=18 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=19
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=19
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=20
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=20
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT cid FROM xycms_productcate WHERE parentid=21
4362706 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=21
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_albumcate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
4362706 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 in (914,913,912,911,910) ORDER BY v.orders DESC
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl,b.title AS brand FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid LEFT JOIN xycms_brand AS b ON v.brandid = b.id WHERE v.flag=1 AND v.id='909'
4362706 Query SELECT * FROM xycms_region where flag=1
4362706 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=5
4362706 Query SELECT * FROM xycms_region ORDER BY orders ASC
4362706 Query SELECT a.*,c.username FROM xycms_comments AS a LEFT JOIN xycms_user AS c ON a.user_id=c.id where a.flag=1 and a.product_id=909 ORDER BY a.message_time DESC
4362706 Query SELECT v.* FROM xycms_download AS v LEFT JOIN xycms_files AS c ON v.id=c.download_id WHERE c.model='product' AND c.model_id='909'
4362706 Query SELECT parentid FROM xycms_productcate WHERE flag = 1 AND cid = 5
4362706 Query SELECT * FROM xycms_extend WHERE cid IN (0,5) AND flag = 1
4362706 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
4362706 Query SELECT orders FROM xycms_product where id='909' and flag=1
4362706 Query SELECT id,title,orders FROM xycms_product WHERE orders > 462 AND cid=(SELECT cid FROM xycms_product WHERE id = 909) AND front=1 ORDER BY orders DESC
4362706 Query SELECT orders FROM xycms_product where id='909' and flag=1
4362706 Query SELECT id,title,orders FROM xycms_product WHERE orders < 462 AND cid=(SELECT cid FROM xycms_product WHERE id = 909) AND front=1 ORDER BY orders DESC
4362706 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=5
4362706 Query SELECT depth, parentid, front FROM xycms_productcate WHERE flag=1 AND cid=5
4362706 Query SELECT depth FROM xycms_productcate WHERE cid=5
4362706 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders,cid DESC
4362706 Query SELECT banner,parentid FROM xycms_productcate where cid=5
4362707 Connect root@localhost on
4362707 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
4362706 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 ASC LIMIT 8
4362707 Init DB mysql
4362706 Quit
4362707 Init DB mysql
4362707 Query SET GLOBAL general_log=OFF