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
319084 Query select @@datadir
319084 Quit
241022 11:50:37 319085 Connect root@localhost on
319085 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319085 Query SET sql_mode=''
319085 Init DB syzzrs
319085 Query SELECT * FROM xycms_config LIMIT 1
319085 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319085 Query SELECT * FROM xycms_region WHERE `en`='zunhua'
319085 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319085 Query Select * From xycms_sp
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=45
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=48
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=49
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=50
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319085 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
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 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
319085 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
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=12
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=25
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=26
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319085 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
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=43
319085 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
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=19
319085 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
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=20
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=21
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319085 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
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=22
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=46
319085 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
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
241022 11:50:38 319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=44
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=47
319085 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319085 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
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region
319085 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319085 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319085 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
319085 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
319085 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
319085 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
319085 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
319085 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319085 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
319085 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
319085 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
319085 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
319085 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
319085 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
319085 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
319085 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319085 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
319085 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319085 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319085 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319085 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
319085 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
319085 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
319085 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
319085 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
319085 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319085 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319085 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319085 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
319085 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319085 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319085 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319085 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
319085 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC
319085 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC
319085 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='336'
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=47
319085 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319085 Query SELECT * FROM xycms_region
319085 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%æ·˜æ°”å ¡%' or tag like '%æ·˜æ°”å ¡ä»·æ ¼%' or tag like '%æ·˜æ°”å ¡æ‰¹å‘%') and `id` <> 336 ORDER BY timeline DESC limit 10
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_region where flag=1
319085 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%æ·˜æ°”å ¡%' or tag like '%æ·˜æ°”å ¡ä»·æ ¼%' or tag like '%æ·˜æ°”å ¡æ‰¹å‘%' ORDER BY timeline DESC limit 10
319085 Query SELECT orders FROM xycms_product where id='336' and flag=1
319085 Query SELECT id,title,orders FROM xycms_product WHERE orders > 137 AND cid=(SELECT cid FROM xycms_product WHERE id = 336) AND front=1 ORDER BY orders DESC
319085 Query SELECT orders FROM xycms_product where id='336' and flag=1
319085 Query SELECT id,title,orders FROM xycms_product WHERE orders < 137 AND cid=(SELECT cid FROM xycms_product WHERE id = 336) AND front=1 ORDER BY orders DESC
319085 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=47
319085 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=44
319085 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=44
319085 Query SELECT depth FROM xycms_productcate WHERE cid=44
319085 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319085 Query SELECT depth FROM xycms_productcate WHERE cid=47
319085 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319085 Query SELECT depth FROM xycms_productcate WHERE cid=55
319085 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319085 Query SELECT depth FROM xycms_productcate WHERE cid=56
319085 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319085 Query SELECT depth FROM xycms_productcate WHERE cid=57
319085 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319085 Query SELECT depth FROM xycms_productcate WHERE cid=58
319085 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319085 Query SELECT depth FROM xycms_productcate WHERE cid=59
319085 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319085 Quit
241022 11:50:57 319086 Connect root@localhost on
319086 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319086 Query SET sql_mode=''
319086 Init DB syzzrs
319086 Query SELECT * FROM xycms_config LIMIT 1
319086 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319086 Query SELECT * FROM xycms_region WHERE `en`='dalian'
319086 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319086 Query Select * From xycms_sp
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=45
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=48
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=49
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=50
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319086 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
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 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
319086 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
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=12
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=25
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=26
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319086 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
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=43
319086 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
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=19
319086 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
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=20
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=21
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319086 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
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=22
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=46
319086 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
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=44
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=47
319086 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319086 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
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region
319086 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319086 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319086 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
319086 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
319086 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
319086 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
319086 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
319086 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319086 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
319086 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
319086 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
319086 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
319086 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
319086 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
319086 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
319086 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319086 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
319086 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319086 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319086 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319086 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
319086 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
319086 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
319086 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
319086 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
319086 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319086 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319086 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319086 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
319086 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319086 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319086 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319086 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
319086 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC
319086 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC
319086 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='403'
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=49
319086 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319086 Query SELECT * FROM xycms_region
319086 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%   室外å¥èº«å™¨æ%' or tag like '%室外å¥èº«å™¨æä»·æ ¼%' or tag like '%室外å¥èº«å™¨æ批å‘%') and `id` <> 403 ORDER BY timeline DESC limit 10
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_region where flag=1
319086 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%   室外å¥èº«å™¨æ%' or tag like '%室外å¥èº«å™¨æä»·æ ¼%' or tag like '%室外å¥èº«å™¨æ批å‘%' ORDER BY timeline DESC limit 10
319086 Query SELECT orders FROM xycms_product where id='403' and flag=1
319086 Query SELECT id,title,orders FROM xycms_product WHERE orders > 204 AND cid=(SELECT cid FROM xycms_product WHERE id = 403) AND front=1 ORDER BY orders DESC
319086 Query SELECT orders FROM xycms_product where id='403' and flag=1
319086 Query SELECT id,title,orders FROM xycms_product WHERE orders < 204 AND cid=(SELECT cid FROM xycms_product WHERE id = 403) AND front=1 ORDER BY orders DESC
319086 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=49
319086 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=45
319086 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=1
319086 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=1
319086 Query SELECT depth FROM xycms_productcate WHERE cid=1
319086 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319086 Query SELECT depth FROM xycms_productcate WHERE cid=45
319086 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319086 Query SELECT depth FROM xycms_productcate WHERE cid=48
319086 Query SELECT depth FROM xycms_productcate WHERE cid=49
319086 Query SELECT depth FROM xycms_productcate WHERE cid=50
319086 Query SELECT depth FROM xycms_productcate WHERE cid=51
319086 Query SELECT depth FROM xycms_productcate WHERE cid=52
319086 Query SELECT depth FROM xycms_productcate WHERE cid=53
319086 Query SELECT depth FROM xycms_productcate WHERE cid=54
319086 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319086 Quit
241022 11:50:58 319087 Connect root@localhost on
319087 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319087 Query SET sql_mode=''
319087 Init DB ycran
319088 Connect root@localhost on
319088 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319088 Query SET sql_mode=''
319088 Init DB qishunyun
319087 Query SELECT * FROM xycms_config LIMIT 1
319087 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319088 Query SELECT * FROM xycms_config LIMIT 1
319088 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319087 Query SELECT * FROM xycms_region WHERE `en`='chizhou'
319087 Query Select * From xycms_sp
319087 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
319088 Query SELECT * FROM xycms_region WHERE `en`='baotinglizumiaozuzizhixian'
319088 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319088 Query Select * From xycms_sp
319088 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319088 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
319087 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
319088 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
319087 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
319088 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319088 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
319088 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319088 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
319088 Query SELECT * FROM xycms_region where flag=1
319087 Query SELECT * FROM xycms_region WHERE `en`='chizhou'
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319087 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319088 Query SELECT * FROM xycms_region where flag=1
319087 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
319087 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
319088 Query SELECT * FROM xycms_region where flag=1
319087 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
319087 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
319088 Query SELECT * FROM xycms_region where flag=1
319087 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319087 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
319088 Query SELECT * FROM xycms_region where flag=1
319087 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
319088 Query SELECT * FROM xycms_region where flag=1
319087 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
319087 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
319088 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319087 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
319088 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
319087 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
319087 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
319088 Query SELECT * FROM xycms_region where flag=1
319087 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
319088 Query SELECT * FROM xycms_region where flag=1
319087 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319087 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
319088 Query SELECT * FROM xycms_region where flag=1
319087 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319087 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319087 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319087 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
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319088 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
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319088 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
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319088 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
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT cid FROM xycms_productcate WHERE parentid=6
319088 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
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319088 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
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319088 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
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT * FROM xycms_region where flag=1
319088 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319088 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
319088 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
319088 Query SELECT * FROM xycms_region
319088 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319088 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319088 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
319088 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
319088 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
319088 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
319088 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
319088 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 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
319088 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319088 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
319088 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319088 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319088 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319088 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
319087 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
319088 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
319087 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
319088 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
319087 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
319087 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
319087 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319088 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
319087 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319088 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
319087 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319088 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319087 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
319088 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319087 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319088 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319087 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319088 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319087 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319088 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
319087 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
319087 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
319088 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319087 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
319088 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319087 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
319088 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319087 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
319088 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319087 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
319088 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
319087 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
319088 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319087 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
319088 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319087 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
319088 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319087 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
319088 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319087 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
319088 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319087 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
319087 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
319088 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319087 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
319088 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
319087 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
319088 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
319088 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319088 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
319088 Query SELECT * FROM xycms_productcate WHERE parentid=10 AND flag=1 AND front=1 ORDER BY orders ASC
319087 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='144'
319088 Query SELECT * FROM xycms_productcate WHERE parentid=11 AND flag=1 AND front=1 ORDER BY orders ASC
319087 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319088 Query SELECT COUNT(id) FROM .xycms_guestbook WHERE `isread`='0'
319088 Query SELECT * FROM xycms_region
319087 Query SELECT * FROM xycms_region
319087 Query SELECT * FROM xycms_product WHERE ( tag like '%槽å¼æ¡¥æž¶%' or tag like '%槽å¼æ¡¥æž¶åŽ‚家%' or tag like '%槽å¼æ¡¥æž¶ä»·æ ¼%') and `id` <> 144 ORDER BY timeline DESC limit 10
319087 Query SELECT * FROM xycms_info WHERE tag like '%槽å¼æ¡¥æž¶%' or tag like '%槽å¼æ¡¥æž¶åŽ‚家%' or tag like '%槽å¼æ¡¥æž¶ä»·æ ¼%' ORDER BY timeline DESC limit 10
319087 Query SELECT id,title FROM xycms_product WHERE id < 144 AND cid=(SELECT cid FROM xycms_product WHERE id = 144) AND front=1 ORDER BY id DESC LIMIT 1
319087 Query SELECT id,title FROM xycms_product WHERE id>144 AND cid=(SELECT cid FROM xycms_product WHERE id = 144) AND front=1 ORDER BY id ASC LIMIT 1
319087 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=12
319087 Query SELECT depth FROM xycms_productcate WHERE cid=12
319087 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319088 Quit
319087 Quit
241022 11:50:59 319089 Connect root@localhost on
319089 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319089 Query SET sql_mode=''
319089 Init DB ycran
319089 Query SELECT * FROM xycms_config LIMIT 1
319089 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319089 Query SELECT * FROM xycms_region WHERE `en`='zaozhuang'
319089 Query Select * From xycms_sp
319089 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
319089 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
319089 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
319089 Query SELECT * FROM xycms_region WHERE `en`='zaozhuang'
319089 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319089 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
319089 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
319089 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
319089 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
319089 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319089 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
319089 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319089 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319089 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319089 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
319089 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
319089 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
319089 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
319089 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
319089 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319089 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319089 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319089 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
319089 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319089 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319089 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 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
319089 Query select cid from xycms_productcate where word='cpflsf1e'
319089 Query SELECT cid FROM xycms_productcate WHERE parentid=6
319089 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='6'
319089 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
319089 Query select * from xycms_productcate where cid ='6' LIMIT 1
319089 Query SELECT * FROM xycms_productcate WHERE cid='6' LIMIT 1
319089 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=6
319089 Query SELECT depth FROM xycms_productcate WHERE cid=6
319089 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319089 Quit
241022 11:51:02 319090 Connect root@localhost on
319090 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319090 Query Set global general_log='on'
319090 Query select @@datadir
319090 Query Set global general_log_file='D:\\phpStudy\\WWW\\111jiechu.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
319090 Query select @@datadir
319090 Quit
241022 11:51:09 319091 Connect root@localhost on
319091 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319091 Query SET sql_mode=''
319091 Init DB syzzrs
319091 Query SELECT * FROM xycms_config LIMIT 1
319091 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319091 Query SELECT * FROM xycms_region WHERE `en`='zibo'
319091 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319091 Query Select * From xycms_sp
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=45
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=48
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=49
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=50
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319091 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
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 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
319091 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
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=12
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=25
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=26
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319091 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
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=43
319091 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
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=19
319091 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
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=20
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=21
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319091 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
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=22
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=46
319091 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
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=44
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=47
319091 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319091 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
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT * FROM xycms_region
319091 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319091 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319091 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
319091 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
319091 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
319091 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
319091 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
319091 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319091 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
319091 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
319091 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
319091 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
319091 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
319091 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
319091 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
319091 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319091 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
319091 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319091 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319091 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319091 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
319091 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
319091 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
319091 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
319091 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
319091 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319091 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319091 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319091 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
319091 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319091 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319091 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319091 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
319091 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC
241022 11:51:10 319091 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC
319091 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC
319091 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='808'
319091 Query SELECT * FROM xycms_region where flag=1
319091 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=75
319091 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319091 Query SELECT * FROM xycms_region
319091 Query SELECT orders FROM xycms_product where id='808' and flag=1
319091 Query SELECT id,title,orders FROM xycms_product WHERE orders > 609 AND cid=(SELECT cid FROM xycms_product WHERE id = 808) AND front=1 ORDER BY orders DESC
319091 Query SELECT orders FROM xycms_product where id='808' and flag=1
319091 Query SELECT id,title,orders FROM xycms_product WHERE orders < 609 AND cid=(SELECT cid FROM xycms_product WHERE id = 808) AND front=1 ORDER BY orders DESC
319091 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=75
319091 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=75
319091 Query SELECT depth FROM xycms_productcate WHERE cid=75
319091 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319091 Quit
241022 11:51:12 319092 Connect root@localhost on
319092 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319092 Quit
241022 11:51:13 319093 Connect root@localhost on
319093 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319093 Query SHOW DATABASES
319093 Query SHOW TABLE STATUS FROM `11_yizhou`
319094 Connect root@localhost on
319094 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319093 Query SHOW TABLES FROM `11_yizhou`
319094 Init DB 11_yizhou
319093 Quit
319094 Query SHOW TABLES FROM `11_yizhou`
319094 Query SHOW TABLE STATUS FROM `11_yizhou`
319094 Query SELECT CURRENT_USER()
319094 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT'
319094 Query SELECT CURRENT_USER()
319094 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
319094 Query SHOW MASTER STATUS
319094 Query SHOW SLAVE STATUS
319094 Init DB 11_yizhou
319094 Query SHOW VARIABLES LIKE 'collation_database'
319094 Query SHOW VARIABLES LIKE 'storage_engine'
319094 Quit
241022 11:51:15 319095 Connect root@localhost on
319095 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319095 Quit
319096 Connect root@localhost on
319096 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319096 Query SHOW DATABASES
319096 Quit
319097 Connect root@localhost on
319097 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319097 Init DB mysql
319097 Query SHOW MASTER LOGS
319097 Quit
241022 11:51:18 319098 Connect root@localhost on
319098 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319098 Quit
241022 11:51:19 319099 Connect root@localhost on
319099 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319099 Init DB mysql
319099 Query SHOW MASTER LOGS
319099 Query SELECT USER()
319099 Quit
319100 Connect root@localhost on
319100 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319100 Query SHOW DATABASES
319100 Quit
241022 11:51:33 319101 Connect root@localhost on
319101 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319101 Quit
241022 11:51:34 319102 Connect root@localhost on
319102 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319102 Query SHOW DATABASES
319102 Quit
319103 Connect root@localhost on
319103 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319103 Init DB mysql
319103 Query SHOW MASTER LOGS
319103 Query SELECT USER()
319103 Quit
241022 11:51:35 319104 Connect root@localhost on
319104 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319104 Query SET sql_mode=''
319104 Init DB syzzrs
319104 Query SELECT * FROM xycms_config LIMIT 1
319104 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319104 Query SELECT * FROM xycms_region WHERE `en`='zibo'
319104 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319104 Query Select * From xycms_sp
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=45
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=48
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=49
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=50
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319104 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
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 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
319104 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
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=12
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=25
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=26
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319104 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
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=43
319104 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
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=19
319104 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
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=20
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=21
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319104 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
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=22
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=46
319104 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
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=44
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=47
319104 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319104 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
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region
319104 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319104 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319104 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
241022 11:51:36 319104 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
319104 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
319104 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
319104 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
319104 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319104 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
319104 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
319104 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
319104 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
319104 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
319104 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
319104 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
319104 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319104 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
319104 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319104 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319104 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319104 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
319104 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
319104 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
319104 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
319104 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
319104 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319104 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319104 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319104 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
319104 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319104 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319104 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319104 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
319104 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC
319104 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC
319104 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='738'
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=75
319104 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319104 Query SELECT * FROM xycms_region
319104 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%休闲椅%' or tag like '%休闲椅批å‘ä»·æ ¼%' or tag like '%休闲椅批å‘批å‘%') and `id` <> 738 ORDER BY timeline DESC limit 10
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_region where flag=1
319104 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%休闲椅%' or tag like '%休闲椅批å‘ä»·æ ¼%' or tag like '%休闲椅批å‘批å‘%' ORDER BY timeline DESC limit 10
319104 Query SELECT orders FROM xycms_product where id='738' and flag=1
319104 Query SELECT id,title,orders FROM xycms_product WHERE orders > 539 AND cid=(SELECT cid FROM xycms_product WHERE id = 738) AND front=1 ORDER BY orders DESC
319104 Query SELECT orders FROM xycms_product where id='738' and flag=1
319104 Query SELECT id,title,orders FROM xycms_product WHERE orders < 539 AND cid=(SELECT cid FROM xycms_product WHERE id = 738) AND front=1 ORDER BY orders DESC
319104 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=75
319104 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=75
319104 Query SELECT depth FROM xycms_productcate WHERE cid=75
319104 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319104 Quit
319105 Connect root@localhost on
319105 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319105 Init DB mysql
319105 Query SHOW MASTER LOGS
241022 11:51:37 319105 Quit
319106 Connect root@localhost on
319106 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319106 Quit
241022 11:51:53 319107 Connect root@localhost on
319107 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319107 Query set global general_log_file='D:\phpStudy\WWW\damudi.php'