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
319300 Quit
241022 12:01:41 319301 Connect root@localhost on
319301 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319301 Query SET sql_mode=''
319301 Init DB syzzrs
319301 Query SELECT * FROM xycms_config LIMIT 1
319301 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319301 Query SELECT * FROM xycms_region WHERE `en`='yuanjiang'
319301 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319301 Query Select * From xycms_sp
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=45
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=48
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=49
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=50
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319301 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
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 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
319301 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
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=12
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=25
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=26
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319301 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
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=43
319301 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
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=19
319301 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
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=20
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=21
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319301 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
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=22
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=46
319301 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
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=44
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=47
319301 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319301 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
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region
319301 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319301 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319301 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
319301 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
319301 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
319301 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
319301 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
319301 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319301 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
319301 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
319301 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
319301 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
319301 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
319301 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
319301 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
319301 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319301 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
319301 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319301 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319301 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319301 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
319301 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
319301 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
319301 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
319301 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
319301 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319301 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319301 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319301 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
319301 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319301 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319301 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319301 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
319301 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC
319301 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC
319301 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='959'
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=26
319301 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319301 Query SELECT * FROM xycms_region
319301 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%金属垃圾桶%' or tag like '%é‡‘å±žåžƒåœ¾æ¡¶ä»·æ ¼%' or tag like '%金属垃圾桶批å‘%') and `id` <> 959 ORDER BY timeline DESC limit 10
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_region where flag=1
319301 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%金属垃圾桶%' or tag like '%é‡‘å±žåžƒåœ¾æ¡¶ä»·æ ¼%' or tag like '%金属垃圾桶批å‘%' ORDER BY timeline DESC limit 10
319301 Query SELECT orders FROM xycms_product where id='959' and flag=1
319301 Query SELECT id,title,orders FROM xycms_product WHERE orders > 760 AND cid=(SELECT cid FROM xycms_product WHERE id = 959) AND front=1 ORDER BY orders DESC
319301 Query SELECT orders FROM xycms_product where id='959' and flag=1
319301 Query SELECT id,title,orders FROM xycms_product WHERE orders < 760 AND cid=(SELECT cid FROM xycms_product WHERE id = 959) AND front=1 ORDER BY orders DESC
319301 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=26
319301 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=12
319301 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=2
319301 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=2
319301 Query SELECT depth FROM xycms_productcate WHERE cid=2
319301 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319301 Query SELECT depth FROM xycms_productcate WHERE cid=12
319301 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319301 Query SELECT depth FROM xycms_productcate WHERE cid=25
319301 Query SELECT depth FROM xycms_productcate WHERE cid=26
319301 Query SELECT depth FROM xycms_productcate WHERE cid=27
319301 Query SELECT depth FROM xycms_productcate WHERE cid=28
319301 Query SELECT depth FROM xycms_productcate WHERE cid=29
319301 Quit
241022 12:01:45 319302 Connect root@localhost on
319302 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319302 Query SET sql_mode=''
319302 Init DB zhengzhoupeng
319302 Query SELECT * FROM xycms_config LIMIT 1
319302 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319302 Query SELECT * FROM xycms_region WHERE `en`='puyang'
319302 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319302 Query Select * From xycms_sp
319302 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 4
319302 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 8
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319302 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 6
319302 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
319302 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319302 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319302 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4
319302 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319302 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 4
319302 Query SELECT * FROM xycms_region
319302 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319302 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319302 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
319302 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
319302 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
319302 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319302 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
319302 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
319302 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
319302 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
319302 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
319302 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319302 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
319302 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319302 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319302 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319302 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
241022 12:01:46 319303 Connect root@localhost on
319303 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319303 Query SET sql_mode=''
319303 Init DB lfxkhk
319303 Query SELECT * FROM xycms_config LIMIT 1
319303 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319303 Query SELECT * FROM xycms_region WHERE `en`='jiyuan'
319303 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319303 Query Select * From xycms_sp
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 2
319303 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders ASC LIMIT 6
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 3
319303 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
319303 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 5
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 5
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 5
319303 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 8
319303 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders ASC LIMIT 6
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 10
319303 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
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319303 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='27' ORDER BY v.orders DESC LIMIT 4
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319303 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='28' ORDER BY v.orders DESC LIMIT 4
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319303 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='29' ORDER BY v.orders DESC LIMIT 4
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 6
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 1
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319303 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
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 1
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319303 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 6
319303 Query SELECT * FROM xycms_searchtype
319303 Query SELECT * FROM xycms_region ORDER BY orders ASC
319303 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319303 Query SELECT * FROM xycms_onlinechat WHERE flag=1
319303 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319303 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
319303 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
319303 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
319303 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
319303 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 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
319303 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319303 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319303 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319303 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
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319303 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319303 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319303 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
319302 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
319303 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
319302 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
319303 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
319302 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
319303 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
319302 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
319303 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319302 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319302 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319303 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3
319302 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319302 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
319303 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319302 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319302 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319303 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4
319302 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319302 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319303 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319302 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
319303 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319303 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=5
319302 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT cid FROM xycms_casecate WHERE parentid=1
319303 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=1
319303 Query SELECT * FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319303 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319303 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319303 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319303 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5'
319303 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319303 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5' LIMIT 10
319303 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
319303 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319302 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='218'
319303 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=3
319303 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319303 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_region
319303 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_product WHERE ( tag like '%é“精粉%' or tag like '%é“ç²¾ç²‰ä»·æ ¼%') and `id` <> 218 ORDER BY timeline DESC limit 10
319303 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=68 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='51' LIMIT 10
319302 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='52' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='53' LIMIT 10
319302 Query SELECT * FROM xycms_info WHERE tag like '%é“精粉%' or tag like '%é“ç²¾ç²‰ä»·æ ¼%' ORDER BY timeline DESC limit 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='54' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='55' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='56' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='57' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='58' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='59' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='60' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='61' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='62' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='63' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='64' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='65' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='66' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='67' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='68' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='69' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='70' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='71' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='72' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='73' LIMIT 10
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='74' LIMIT 10
319302 Query SELECT orders FROM xycms_product where id='218' and flag=1
319303 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='75' LIMIT 10
319302 Query SELECT id,title,orders FROM xycms_product WHERE orders > 10 AND cid=(SELECT cid FROM xycms_product WHERE id = 218) AND front=1 ORDER BY orders DESC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319302 Query SELECT orders FROM xycms_product where id='218' and flag=1
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=51
319302 Query SELECT id,title,orders FROM xycms_product WHERE orders < 10 AND cid=(SELECT cid FROM xycms_product WHERE id = 218) AND front=1 ORDER BY orders DESC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=3
319303 Query SELECT * FROM xycms_region where flag=1
319302 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=3
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319302 Query SELECT depth FROM xycms_productcate WHERE cid=3
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=52
319302 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319303 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC
319302 Query SELECT banner,parentid FROM xycms_productcate where cid=3
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=53
319303 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=54
319303 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=55
319303 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=56
319303 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=57
319303 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=58
319303 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=59
319303 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=60
319303 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=61
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=61
319303 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=62
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=62
319303 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=63
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=63
319303 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=64
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=64
319303 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=65
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=65
319303 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=66
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=66
319303 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=67
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=67
319303 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=68
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=68
319303 Query SELECT * FROM xycms_productcate WHERE parentid=68 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=69
319303 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=70
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=70
319303 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=71
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=71
319303 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=72
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=72
319303 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=73
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=73
319303 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=74
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=74
319303 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT cid FROM xycms_productcate WHERE parentid=75
319303 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=75
319303 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319303 Query SELECT * FROM xycms_region where flag=1
319303 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='1109'
319302 Quit
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=70
319303 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319303 Query SELECT * FROM xycms_region ORDER BY orders ASC
319303 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319303 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%机务实è®è®¾å¤‡%' or tag like '%%' or tag like '%%') and `id` <> 1109 ORDER BY timeline DESC limit 10
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_region where flag=1
319303 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%机务实è®è®¾å¤‡%' or tag like '%%' or tag like '%%' ORDER BY timeline DESC limit 10
319303 Query SELECT orders FROM xycms_product where id='1109' and flag=1
319303 Query SELECT id,title,orders FROM xycms_product WHERE orders > 337 AND cid=(SELECT cid FROM xycms_product WHERE id = 1109) AND front=1 ORDER BY orders DESC
319303 Query SELECT orders FROM xycms_product where id='1109' and flag=1
319303 Query SELECT id,title,orders FROM xycms_product WHERE orders < 337 AND cid=(SELECT cid FROM xycms_product WHERE id = 1109) AND front=1 ORDER BY orders DESC
319303 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=70
319303 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=70
319303 Query SELECT depth FROM xycms_productcate WHERE cid=70
319303 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319303 Query SELECT banner,parentid FROM xycms_productcate where cid=70
319303 Quit
319304 Connect root@localhost on
319304 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319304 Query SET sql_mode=''
319304 Init DB zhengzhoupeng
319304 Query SELECT * FROM xycms_config LIMIT 1
319304 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319304 Query SELECT * FROM xycms_region WHERE `en`='datong'
319304 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319304 Query Select * From xycms_sp
319304 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 4
319304 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 8
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319304 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 6
319304 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
319304 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319304 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT * FROM xycms_region where flag=1
319304 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319304 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4
319304 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319304 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 4
319304 Query SELECT * FROM xycms_region
319304 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319304 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319304 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
319304 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
319304 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
319304 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319304 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
319304 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
319304 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
319304 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
319304 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
319304 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319304 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
319304 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319304 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319304 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319304 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
319304 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
319304 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
319304 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
319304 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
319304 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319304 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319304 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319304 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
319304 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319304 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319304 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319304 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319304 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
319304 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319304 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319304 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319304 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319304 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319304 Query SELECT COUNT(id) FROM .xycms_guestbook WHERE `isread`='0'
319304 Query SELECT * FROM xycms_region
319304 Quit
241022 12:01:47 319305 Connect root@localhost on
319305 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319305 Query SET sql_mode=''
319305 Init DB lfxkhk
319305 Query SELECT * FROM xycms_config LIMIT 1
319305 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319305 Query SELECT * FROM xycms_region WHERE `en`='qionghai'
319305 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319305 Query Select * From xycms_sp
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 2
319305 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders ASC LIMIT 6
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 3
319305 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
319305 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 5
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 5
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 5
319305 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 8
319305 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders ASC LIMIT 6
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 10
319305 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
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319305 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='27' ORDER BY v.orders DESC LIMIT 4
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319305 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='28' ORDER BY v.orders DESC LIMIT 4
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319305 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='29' ORDER BY v.orders DESC LIMIT 4
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 6
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 1
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319305 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
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 1
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319305 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 6
319305 Query SELECT * FROM xycms_searchtype
319305 Query SELECT * FROM xycms_region ORDER BY orders ASC
319305 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319305 Query SELECT * FROM xycms_onlinechat WHERE flag=1
319305 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319305 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
319305 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
319305 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
319305 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
319305 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 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
319305 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319305 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319305 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319305 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
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319305 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319305 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319305 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
319305 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
319305 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
319305 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
319305 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319305 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3
319305 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319305 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4
319305 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319305 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319305 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=5
319305 Query SELECT * FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319305 Query SELECT cid FROM xycms_casecate WHERE parentid=1
319305 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=1
319305 Query SELECT * FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319305 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319305 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319305 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319305 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5'
319305 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319305 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5' LIMIT 10
319305 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
319305 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=68 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='51' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='52' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='53' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='54' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='55' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='56' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='57' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='58' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='59' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='60' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='61' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='62' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='63' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='64' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='65' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='66' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='67' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='68' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='69' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='70' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='71' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='72' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='73' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='74' LIMIT 10
319305 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='75' LIMIT 10
319305 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=51
319305 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=52
319305 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=53
319305 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=54
319305 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=55
319305 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=56
319305 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=57
319305 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=58
319305 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=59
319305 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=60
319305 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=61
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=61
319305 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=62
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=62
319305 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=63
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=63
319305 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=64
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=64
319305 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=65
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=65
319305 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=66
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=66
319305 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=67
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=67
319305 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=68
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=68
319305 Query SELECT * FROM xycms_productcate WHERE parentid=68 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=69
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=69
319305 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=70
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=70
319305 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=71
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=71
319305 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=72
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=72
319305 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=73
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=73
319305 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=74
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=74
319305 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT cid FROM xycms_productcate WHERE parentid=75
319305 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=75
319305 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319305 Query SELECT * FROM xycms_region where flag=1
319305 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='1085'
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=48
319305 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319305 Query SELECT * FROM xycms_region ORDER BY orders ASC
319305 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319305 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%轨é“交通实è®è®¾å¤‡%' or tag like '%%' or tag like '%%') and `id` <> 1085 ORDER BY timeline DESC limit 10
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_region where flag=1
319305 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%轨é“交通实è®è®¾å¤‡%' or tag like '%%' or tag like '%%' ORDER BY timeline DESC limit 10
319305 Query SELECT orders FROM xycms_product where id='1085' and flag=1
319305 Query SELECT id,title,orders FROM xycms_product WHERE orders > 313 AND cid=(SELECT cid FROM xycms_product WHERE id = 1085) AND front=1 ORDER BY orders DESC
319305 Query SELECT orders FROM xycms_product where id='1085' and flag=1
319305 Query SELECT id,title,orders FROM xycms_product WHERE orders < 313 AND cid=(SELECT cid FROM xycms_product WHERE id = 1085) AND front=1 ORDER BY orders DESC
319305 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=48
319305 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=48
319305 Query SELECT depth FROM xycms_productcate WHERE cid=48
319305 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319305 Query SELECT banner,parentid FROM xycms_productcate where cid=48
319305 Quit
241022 12:01:48 319306 Connect root@localhost on
319306 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319306 Query SET sql_mode=''
319306 Init DB zhengzhoupeng
319306 Query SELECT * FROM xycms_config LIMIT 1
319306 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319306 Query SELECT * FROM xycms_region WHERE `en`='beijing'
319306 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319306 Query Select * From xycms_sp
319306 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 4
319306 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 8
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319306 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 6
319306 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
319306 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319306 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319306 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4
319306 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319306 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 4
319306 Query SELECT * FROM xycms_region
319306 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319306 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319306 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
319306 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
319306 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
319306 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319306 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
319306 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
319306 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
319306 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
319306 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
319306 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319306 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
319306 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319306 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319306 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319306 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
319306 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
319306 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
319306 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
319306 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
319306 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319306 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319306 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319306 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
319306 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319306 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319306 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319306 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319306 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
319306 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319306 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319306 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319306 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319306 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319306 Query select cid from xycms_productcate where word='cpflsdab'
319306 Query SELECT * FROM xycms_productcate where cid='4'
319306 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319306 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='4'
319306 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='4' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 12
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query select * from xycms_productcate where cid ='4' LIMIT 1
319306 Query SELECT * FROM xycms_region where flag=1
319306 Query SELECT * FROM xycms_productcate WHERE cid='4' LIMIT 1
319306 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=4
319306 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=4
319306 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=4
319306 Query SELECT depth FROM xycms_productcate WHERE cid=4
319306 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319306 Query SELECT banner,parentid FROM xycms_productcate where cid=4
319306 Quit
241022 12:01:49 319307 Connect root@localhost on
319307 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319307 Query SET sql_mode=''
319307 Init DB qtwyjd2
319307 Query SELECT * FROM xycms_config LIMIT 1
319307 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319307 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319307 Query Select * From xycms_sp
319307 Query SELECT * FROM xycms_searchtype
319307 Query SELECT * FROM xycms_region ORDER BY orders ASC
319307 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319307 Query SELECT * FROM xycms_onlinechat WHERE flag=1
319307 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319307 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
319307 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
319307 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
319307 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
319307 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
319307 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319307 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
319307 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
319307 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
319307 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
319307 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
319307 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
319307 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
319307 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319307 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319307 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319307 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 ORDER BY c.orders ASC
319307 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319307 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319307 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319307 Query SELECT v.* FROM xycms_brand AS v WHERE v.flag=1 ORDER BY v.orders ASC
319307 Query SELECT v.* FROM xycms_brand AS v WHERE v.flag=1 ORDER BY v.orders ASC
319307 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
319307 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
319307 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
319307 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
319307 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319307 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=1
319307 Query SELECT * FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319307 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3
319307 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319307 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4
319307 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='1' LIMIT 10
319307 Query SELECT v.*,c.cname FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='3' LIMIT 10
319307 Query SELECT v.*,c.cname FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='4' LIMIT 10
319307 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_casecate WHERE parentid=1
319307 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=1
319307 Query SELECT * FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=1
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=7
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=8
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=9
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=10
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=11
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=12
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=13
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=14
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=15
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=16
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=17
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND (cid=1 OR cid=7 OR cid=8 OR cid=9 OR cid=10 OR cid=11 OR cid=12 OR cid=13 OR cid=14 OR cid=15 OR cid=16 OR cid=17)
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=7
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=7
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=7 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=8
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=8
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=8 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=9
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=9
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=9 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=10
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=10
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=10 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=11
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=11
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=11 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=12
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=12
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=12 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=13
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=13
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=13 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=14
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=14
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=14 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=15
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=15
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=15 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=16
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=16
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=16 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=17
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=17
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=17 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=2
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=2
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=3
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=3
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=4
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=4
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=5
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=24
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=25
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=26
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=27
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=28
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=29
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND (cid=5 OR cid=24 OR cid=25 OR cid=26 OR cid=27 OR cid=28 OR cid=29)
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=24
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=24
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=24 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=25
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=25
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=25 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=26
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=26
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=26 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=27
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=27
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=27 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=28
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=28
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=28 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=29
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=29
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=29 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=6
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=20
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=21
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=22
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=23
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND (cid=6 OR cid=20 OR cid=21 OR cid=22 OR cid=23)
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=6 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=20
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=20
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=20 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=21
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=21
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=21 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=22
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=22
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=22 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=23
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=23
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=23 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=18
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=18
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=18 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=19
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=30
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=31
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=32
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=33
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=34
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=35
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=36
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND (cid=19 OR cid=30 OR cid=31 OR cid=32 OR cid=33 OR cid=34 OR cid=35 OR cid=36)
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=19 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=30
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=30
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=30 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=31
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=31
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=31 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=32
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=32
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=32 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=33
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=33
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=33 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=34
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=34
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=34 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=35
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=35
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=35 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_albumcate WHERE parentid=36
319307 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=36
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=36 AND flag=1 ORDER BY orders ASC
319307 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='10'
319307 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='10' LIMIT 10
319307 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='11'
319307 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='11' LIMIT 10
319307 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
319307 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_productcate WHERE parentid=24 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='30' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='29' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='31' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=31 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='32' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='33' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='34' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='35' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='36' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='25' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=25 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='8' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='7' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='27' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=27 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='28' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=28 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='26' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=26 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='64' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='65' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='37' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=37 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='38' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=38 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='40' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=40 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='41' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=41 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='42' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=42 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='43' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=43 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='44' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='9' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='22' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='45' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='46' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='47' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='48' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='49' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='50' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='51' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='52' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='53' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='54' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='55' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='56' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='57' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='58' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='59' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='60' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='61' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='62' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='63' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='14' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=14 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='15' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='16' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=16 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='17' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=17 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='18' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=18 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='19' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='20' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='21' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='24' LIMIT 10
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='1' LIMIT 10
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='2' LIMIT 10
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='3' LIMIT 10
319307 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='6' LIMIT 10
319307 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=24
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=30
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=31
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=32
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=33
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=34
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=35
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=36
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND (cid=24 OR cid=29 OR cid=30 OR cid=31 OR cid=32 OR cid=33 OR cid=34 OR cid=35 OR cid=36)
319307 Query SELECT * FROM xycms_productcate WHERE parentid=24 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=30
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=30
319307 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=29
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=29
319307 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=31
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=31
319307 Query SELECT * FROM xycms_productcate WHERE parentid=31 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=32
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=32
319307 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=33
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=33
319307 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=34
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=34
319307 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=35
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=35
319307 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=36
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=36
319307 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=65
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=26
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=25
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=64
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND (cid=1 OR cid=65 OR cid=7 OR cid=8 OR cid=26 OR cid=25 OR cid=64 OR cid=27 OR cid=28)
319307 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=25
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=25
319307 Query SELECT * FROM xycms_productcate WHERE parentid=25 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=8
319307 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=7
319307 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=27
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=27
319307 Query SELECT * FROM xycms_productcate WHERE parentid=27 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=28
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=28
319307 Query SELECT * FROM xycms_productcate WHERE parentid=28 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=26
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=26
319307 Query SELECT * FROM xycms_productcate WHERE parentid=26 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=64
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=64
319307 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=65
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=65
319307 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=44
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=37
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=38
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=40
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=41
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=42
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=43
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND (cid=2 OR cid=44 OR cid=37 OR cid=38 OR cid=40 OR cid=41 OR cid=42 OR cid=43)
319307 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=37
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=37
319307 Query SELECT * FROM xycms_productcate WHERE parentid=37 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=38
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=38
319307 Query SELECT * FROM xycms_productcate WHERE parentid=38 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=40
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=40
319307 Query SELECT * FROM xycms_productcate WHERE parentid=40 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=41
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=41
319307 Query SELECT * FROM xycms_productcate WHERE parentid=41 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=42
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=42
319307 Query SELECT * FROM xycms_productcate WHERE parentid=42 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=43
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=43
319307 Query SELECT * FROM xycms_productcate WHERE parentid=43 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=44
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=44
319307 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=9
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=22
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=46
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=45
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=47
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=48
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=49
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=50
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=61
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=63
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=62
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND (cid=3 OR cid=9 OR cid=22 OR cid=46 OR cid=45 OR cid=47 OR cid=48 OR cid=49 OR cid=50 OR cid=51 OR cid=52 OR cid=53 OR cid=54 OR cid=55 OR cid=56 OR cid=57 OR cid=58 OR cid=59 OR cid=60 OR cid=61 OR cid=63 OR cid=62)
319307 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=9
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=9
319307 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=22
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=22
319307 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=45
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=45
319307 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=46
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=46
319307 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=47
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=47
319307 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=48
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=48
319307 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=49
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=49
319307 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=50
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=50
319307 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=51
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=51
319307 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=52
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=52
319307 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=53
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=53
319307 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=54
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=54
319307 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=55
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=55
319307 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=56
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=56
319307 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=57
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=57
319307 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=58
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=58
319307 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=59
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=59
319307 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=60
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=60
319307 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=61
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=61
319307 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=62
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=62
319307 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=63
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=63
319307 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=6
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=14
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=16
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=17
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=18
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=19
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=20
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=21
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND (cid=6 OR cid=14 OR cid=15 OR cid=16 OR cid=17 OR cid=18 OR cid=19 OR cid=20 OR cid=21)
319307 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=14
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=14
319307 Query SELECT * FROM xycms_productcate WHERE parentid=14 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=15
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=15
319307 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=16
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=16
319307 Query SELECT * FROM xycms_productcate WHERE parentid=16 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=17
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=17
319307 Query SELECT * FROM xycms_productcate WHERE parentid=17 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=18
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=18
319307 Query SELECT * FROM xycms_productcate WHERE parentid=18 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=19
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=19
319307 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=20
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=20
319307 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 ORDER BY orders ASC
319307 Query SELECT cid FROM xycms_productcate WHERE parentid=21
319307 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=21
319307 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 ORDER BY orders ASC
319307 Query SELECT * FROM xycms_albumcate WHERE parentid=0 AND flag=1 ORDER BY orders ASC
319307 Query SELECT v.*,c.cname,c.word,c.img,c.target,c.linktype,c.linkurl FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.id='621' LIMIT 1
319307 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319307 Query SELECT v.* FROM xycms_download AS v LEFT JOIN xycms_files AS c ON v.id=c.download_id WHERE c.model='info' AND c.model_id='621'
319307 Query SELECT * FROM xycms_product WHERE flag=1 and tag like '%ä¸å°æœº%' or tag like '%ä¸ç½‘å°åˆ·æœº%' or tag like '%玻璃ä¸å°æœº%' ORDER BY timeline DESC limit 10
319307 Query SELECT * FROM xycms_info WHERE (flag=1 and tag like '%ä¸å°æœº%' or tag like '%ä¸ç½‘å°åˆ·æœº%' or tag like '%玻璃ä¸å°æœº%') and `id` <> 621 ORDER BY timeline DESC limit 10
319308 Connect root@localhost on
319308 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319308 Query SET sql_mode=''
319308 Init DB 11_yizhou
319308 Query SELECT * FROM xycms_config LIMIT 1
319307 Query select id,groupid,username,loves,flag from xycms_user where username='' and password=''
319307 Query SELECT id,title FROM xycms_info WHERE id < '621' AND `cid` = '4' ORDER BY id DESC LIMIT 1
319308 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319307 Query SELECT id,title FROM xycms_info WHERE `id` > '621' AND `cid` = '4' ORDER BY id ASC LIMIT 1
319307 Query SELECT cid,cname,parentid,depth FROM xycms_infocate where cid=4
319307 Query SELECT depth, parentid FROM xycms_infocate WHERE flag=1 AND cid=4
319307 Query SELECT depth FROM xycms_infocate WHERE flag=1 AND cid=4
319307 Query SELECT * FROM xycms_infocate WHERE flag=1 AND parentid=4 ORDER BY orders,cid DESC
319307 Query SELECT banner,parentid FROM xycms_infocate where cid=4
319308 Query SELECT * FROM xycms_region WHERE `en`='putian'
319308 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319308 Query Select * From xycms_sp
319308 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319308 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 10
319307 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline ASC LIMIT 6
319308 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319308 Query SELECT * FROM xycms_region where flag=1
319308 Query SELECT * FROM xycms_region where flag=1
319308 Query SELECT * FROM xycms_region where flag=1
319308 Query SELECT * FROM xycms_region where flag=1
319308 Query SELECT * FROM xycms_region where flag=1
319308 Query SELECT * FROM xycms_region where flag=1
319308 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319308 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 10
319308 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 6
319308 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 10
319308 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319308 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 1
319308 Query SELECT * FROM xycms_translate
319308 Query SELECT * FROM xycms_region
319308 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319308 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
319308 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
319308 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319308 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
319308 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
319308 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
319308 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
319308 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319308 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
319308 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319308 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319307 Quit
319308 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319308 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
319308 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
319308 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
319308 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
319308 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
319308 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319308 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319308 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319308 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
319308 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319308 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319308 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319308 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
319308 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319308 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319308 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319308 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319308 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319308 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319308 Query SELECT COUNT(id) FROM .xycms_guestbook WHERE `isread`='0'
319308 Query SELECT * FROM xycms_region
319308 Quit
241022 12:01:50 319309 Connect root@localhost on
319309 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319309 Query SET sql_mode=''
319309 Init DB zhengzhoupeng
319309 Query SELECT * FROM xycms_config LIMIT 1
319309 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319309 Query SELECT * FROM xycms_region WHERE `en`='beijing'
319309 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319309 Query Select * From xycms_sp
319309 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 4
319309 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 8
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319309 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 6
319309 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
319309 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319309 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319309 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4
319309 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319309 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 4
319309 Query SELECT * FROM xycms_region
319309 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319309 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319309 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
319309 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
319309 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
319309 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319309 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
319309 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
319309 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
319309 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
319309 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
319309 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319309 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
319309 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319309 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319309 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319309 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
319309 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
319309 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
319309 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
319309 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
319309 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319309 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319309 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319309 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
319309 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319309 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319309 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319309 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319309 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
319309 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319309 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319309 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319309 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319309 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319309 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='220'
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=3
319309 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319309 Query SELECT * FROM xycms_region
319309 Query SELECT * FROM xycms_product WHERE ( tag like '%é“精粉%' or tag like '%选煤é“ç²¾ç²‰ä»·æ ¼%') and `id` <> 220 ORDER BY timeline DESC limit 10
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_region where flag=1
319309 Query SELECT * FROM xycms_info WHERE tag like '%é“精粉%' or tag like '%选煤é“ç²¾ç²‰ä»·æ ¼%' ORDER BY timeline DESC limit 10
319309 Query SELECT orders FROM xycms_product where id='220' and flag=1
319309 Query SELECT id,title,orders FROM xycms_product WHERE orders > 12 AND cid=(SELECT cid FROM xycms_product WHERE id = 220) AND front=1 ORDER BY orders DESC
319309 Query SELECT orders FROM xycms_product where id='220' and flag=1
319309 Query SELECT id,title,orders FROM xycms_product WHERE orders < 12 AND cid=(SELECT cid FROM xycms_product WHERE id = 220) AND front=1 ORDER BY orders DESC
319309 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=3
319309 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=3
319309 Query SELECT depth FROM xycms_productcate WHERE cid=3
319309 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319309 Query SELECT banner,parentid FROM xycms_productcate where cid=3
319309 Quit
241022 12:01:51 319310 Connect root@localhost on
319310 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319310 Query SET sql_mode=''
319310 Init DB zhengzhoupeng
241022 12:01:52 319310 Query SELECT * FROM xycms_config LIMIT 1
319310 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319310 Query SELECT hits FROM xycms_product WHERE id='220'
319310 Query UPDATE xycms_product SET hits=hits+1 WHERE id='220'
319310 Quit
241022 12:01:53 319311 Connect root@localhost on
319311 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319311 Query SET sql_mode=''
319311 Init DB zhengzhoupeng
319311 Query SELECT * FROM xycms_config LIMIT 1
319311 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319311 Query SELECT * FROM xycms_region WHERE `en`='jingdezhen'
319311 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319311 Query Select * From xycms_sp
319311 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 4
319311 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 8
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319311 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 6
319311 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
319311 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319311 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT * FROM xycms_region where flag=1
319311 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319311 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4
319311 Query SELECT cid FROM xycms_infocate WHERE parentid=4
319311 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 4
319311 Query SELECT * FROM xycms_region
319311 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319311 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319311 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
319311 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
319311 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
319311 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319311 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
319311 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
319311 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
319311 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
319311 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
319311 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319311 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
319311 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
241022 12:01:54 319311 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319311 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319311 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
319311 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
319311 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
319311 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
319311 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
319311 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319311 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319311 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319311 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
319311 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319311 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319311 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319311 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319311 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
319311 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319311 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319311 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319311 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319311 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319311 Query SELECT COUNT(id) FROM .xycms_guestbook WHERE `isread`='0'
319311 Query SELECT * FROM xycms_region
319311 Quit
319312 Connect root@localhost on
319312 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319312 Query SET sql_mode=''
319312 Init DB 11_yizhou
319312 Query SELECT * FROM xycms_config LIMIT 1
319312 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319312 Query SELECT * FROM xycms_region WHERE `en`='hebei'
319312 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319312 Query Select * From xycms_sp
319312 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319312 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 10
319312 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319312 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 10
319312 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 6
319312 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 10
319312 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319312 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='1' ORDER BY v.sticky DESC,v.timeline DESC LIMIT 1
319312 Query SELECT * FROM xycms_translate
319312 Query SELECT * FROM xycms_region
319312 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319312 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
319312 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
319312 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319312 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
319312 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
319312 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
319312 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
319312 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319312 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
319312 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319312 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319313 Connect root@localhost on
319313 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319313 Query SET sql_mode=''
319313 Init DB slznwl
319313 Query SELECT * FROM xycms_config LIMIT 1
319313 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319312 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319312 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
319313 Query SELECT * FROM xycms_region WHERE `en`='suzhou'
319313 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319313 Query Select * From xycms_sp
319313 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319313 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='1' ORDER BY v.timeline DESC LIMIT 1
319312 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
319313 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
319312 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
319312 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
319312 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
319313 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319312 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319312 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319312 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
319312 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319312 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319312 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
319313 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319312 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319312 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319312 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319312 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_region where flag=1
319312 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='235'
319313 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=4
319313 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319312 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc
319313 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 3
319312 Query SELECT * FROM xycms_region
319312 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%高压清洗机管系列%' or tag like '%é«˜åŽ‹æ¸…æ´—æœºä»·æ ¼%' or tag like '%高压清洗机批å‘%') and `id` <> 235 ORDER BY timeline DESC limit 10
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_region where flag=1
319313 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
319312 Query SELECT * FROM xycms_region where flag=1
319312 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%高压清洗机管系列%' or tag like '%é«˜åŽ‹æ¸…æ´—æœºä»·æ ¼%' or tag like '%高压清洗机批å‘%' ORDER BY timeline DESC limit 10
319312 Query SELECT orders FROM xycms_product where id='235' and flag=1
319312 Query SELECT id,title,orders FROM xycms_product WHERE orders > 28 AND cid=(SELECT cid FROM xycms_product WHERE id = 235) AND front=1 ORDER BY orders DESC
319312 Query SELECT orders FROM xycms_product where id='235' and flag=1
319312 Query SELECT id,title,orders FROM xycms_product WHERE orders < 28 AND cid=(SELECT cid FROM xycms_product WHERE id = 235) AND front=1 ORDER BY orders DESC
319312 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=4
319312 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=4
319312 Query SELECT depth FROM xycms_productcate WHERE cid=4
319312 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319312 Query SELECT banner,parentid FROM xycms_productcate where cid=4
319313 Query SELECT cid FROM xycms_casecate WHERE parentid=1
319313 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.orders DESC LIMIT 6
319313 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 4
319313 Query SELECT * FROM xycms_region
319313 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319312 Quit
319313 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319313 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
319313 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
319313 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
319313 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=17 AND v.flag=1 ORDER BY v.orders ASC
319313 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
319313 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
319313 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=20 AND v.flag=1 ORDER BY v.orders ASC
319313 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=21 AND v.flag=1 ORDER BY v.orders ASC
319313 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=22 AND v.flag=1 ORDER BY v.orders ASC
319313 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=23 AND v.flag=1 ORDER BY v.orders ASC
319313 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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
319313 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='21' AND a.flag=1 ORDER BY a.orders ASC
319313 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='22' AND a.flag=1 ORDER BY a.orders ASC
319313 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='23' AND a.flag=1 ORDER BY a.orders ASC
319313 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='24' AND a.flag=1 ORDER BY a.orders ASC
319313 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='25' AND a.flag=1 ORDER BY a.orders ASC
319313 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='26' AND a.flag=1 ORDER BY a.orders ASC
319313 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='27' AND a.flag=1 ORDER BY a.orders ASC
319313 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='29' AND a.flag=1 ORDER BY a.orders ASC
319313 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='30' AND a.flag=1 ORDER BY a.orders ASC
319313 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='31' AND a.flag=1 ORDER BY a.orders ASC
319313 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='32' AND a.flag=1 ORDER BY a.orders ASC
319313 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='33' AND a.flag=1 ORDER BY a.orders ASC
319313 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='34' AND a.flag=1 ORDER BY a.orders ASC
319313 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='35' AND a.flag=1 ORDER BY a.orders ASC
319313 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='36' AND a.flag=1 ORDER BY a.orders ASC
319313 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319313 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
319313 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319313 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319313 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319313 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
319313 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
319313 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
319313 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
319313 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
319313 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319313 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319313 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319313 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
319313 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319313 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319313 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319313 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319313 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
319313 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC
319313 Query select cid from xycms_productcate where word='tsjed1'
319313 Query SELECT * FROM xycms_productcate where cid='83'
319313 Query SELECT cid FROM xycms_productcate WHERE parentid=83
319313 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='83'
319313 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='83' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 20
319313 Query SELECT * FROM xycms_region where flag=1
319313 Query SELECT * FROM xycms_region where flag=1
319313 Query SELECT * FROM xycms_region where flag=1
319313 Query SELECT * FROM xycms_region where flag=1
319313 Query SELECT * FROM xycms_region where flag=1
319313 Query SELECT * FROM xycms_region where flag=1
319313 Query select * from xycms_productcate where cid ='83' LIMIT 1
319313 Query SELECT * FROM xycms_region where flag=1
319313 Query SELECT * FROM xycms_productcate WHERE cid='83' LIMIT 1
319313 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=83
319313 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=83
319313 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=65
319313 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=65
319313 Query SELECT depth FROM xycms_productcate WHERE cid=65
319313 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=75
319313 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=76
319313 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=78
319313 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=79
319313 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=80
319313 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=81
319313 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=82
319313 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=83
319313 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=84
319313 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=86
319313 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT depth FROM xycms_productcate WHERE cid=87
319313 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319313 Query SELECT banner,parentid FROM xycms_productcate where cid=83
319313 Query SELECT banner,parentid FROM xycms_productcate where cid=65
319313 Quit
319314 Connect root@localhost on
319314 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
319314 Query SET sql_mode=''
319314 Init DB qishunyun
319314 Query SELECT * FROM xycms_config LIMIT 1
319314 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1
319314 Query SELECT * FROM xycms_region WHERE `en`='guangdong'
319314 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12
319314 Query Select * From xycms_sp
319314 Query SELECT cid FROM xycms_infocate WHERE parentid=1
319314 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
319314 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
319314 Query SELECT cid FROM xycms_infocate WHERE parentid=5
319314 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
319314 Query SELECT cid FROM xycms_productcate WHERE parentid=1
319314 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
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT cid FROM xycms_productcate WHERE parentid=2
319314 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
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT cid FROM xycms_productcate WHERE parentid=3
319314 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
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319314 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
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT cid FROM xycms_productcate WHERE parentid=5
319314 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
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT cid FROM xycms_productcate WHERE parentid=6
319314 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
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT cid FROM xycms_productcate WHERE parentid=7
319314 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
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT cid FROM xycms_productcate WHERE parentid=8
319314 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
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT cid FROM xycms_infocate WHERE parentid=3
319314 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
319314 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
319314 Query SELECT * FROM xycms_region
319314 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC
319314 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC
319314 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
319314 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
319314 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
319314 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
319314 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
319314 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 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
319314 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC
319314 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
319314 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC
319314 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC
319314 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC
319314 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
319314 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
319314 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
319314 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
319314 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
319314 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319314 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC
319314 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC
319314 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC
319314 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
319314 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC
319314 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC
319314 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319314 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC
319314 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
319314 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=5 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=10 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query SELECT * FROM xycms_productcate WHERE parentid=11 AND flag=1 AND front=1 ORDER BY orders ASC
319314 Query select cid from xycms_productcate where word='qxsjsb2e6'
319314 Query SELECT * FROM xycms_productcate where cid='4'
319314 Query SELECT cid FROM xycms_productcate WHERE parentid=4
319314 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='4'
319314 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='4' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 18
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query select * from xycms_productcate where cid ='4' LIMIT 1
319314 Query SELECT * FROM xycms_region where flag=1
319314 Query SELECT * FROM xycms_productcate WHERE cid='4' LIMIT 1
319314 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=4
319314 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=4
319314 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=4
319314 Query SELECT depth FROM xycms_productcate WHERE cid=4
319314 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders,cid DESC
319314 Query SELECT banner,parentid FROM xycms_productcate where cid=4
319314 Quit
241022 12:01:55 319315 Connect root@localhost on
319315 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
319315 Query Set global general_log_file='D:\\phpStudy\\WWW\\flag.php'