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'