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 321479 Query select @@datadir 321479 Quit 241022 15:06:49 321480 Connect root@localhost on 321480 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321480 Query SET sql_mode='' 321480 Init DB slznwl 321480 Query SELECT * FROM xycms_config LIMIT 1 321480 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321480 Query SELECT * FROM xycms_region WHERE `en`='taizhou' 321480 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321480 Query Select * From xycms_sp 321480 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321480 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 321480 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 321480 Query SELECT * FROM xycms_region where flag=1 321480 Query SELECT * FROM xycms_region where flag=1 321480 Query SELECT * FROM xycms_region where flag=1 321480 Query SELECT * FROM xycms_region where flag=1 321480 Query SELECT * FROM xycms_region where flag=1 321480 Query SELECT * FROM xycms_region where flag=1 321480 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321480 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 321480 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 321480 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321480 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 321480 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 321480 Query SELECT * FROM xycms_region 321480 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321480 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321480 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 321480 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 321480 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 321480 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 321480 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 321480 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 321480 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 321480 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 321480 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 321480 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 321480 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT a.*,z.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 321480 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321480 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 321480 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321480 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321480 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321480 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 321480 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 321480 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 321480 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 321480 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 321480 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321480 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321480 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321480 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 321480 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321480 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321480 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321480 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321480 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 321480 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321480 Query select cid from xycms_productcate where word='mpj9fd' 321480 Query SELECT * FROM xycms_productcate where cid='80' 321480 Query SELECT cid FROM xycms_productcate WHERE parentid=80 321480 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='80' 321480 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='80' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 20 321480 Query SELECT * FROM xycms_region where flag=1 321480 Query select * from xycms_productcate where cid ='80' LIMIT 1 321480 Query SELECT * FROM xycms_region where flag=1 321480 Query SELECT * FROM xycms_productcate WHERE cid='80' LIMIT 1 321480 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=80 321480 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=80 321480 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=65 321480 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=65 321480 Query SELECT depth FROM xycms_productcate WHERE cid=65 321480 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=75 321480 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=76 321480 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=78 321480 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=79 321480 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=80 321480 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=81 321480 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=82 321480 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=83 321480 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=84 321480 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=86 321480 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT depth FROM xycms_productcate WHERE cid=87 321480 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321480 Query SELECT banner,parentid FROM xycms_productcate where cid=80 321480 Query SELECT banner,parentid FROM xycms_productcate where cid=65 321480 Quit 241022 15:06:50 321481 Connect root@localhost on 321481 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321481 Query SET sql_mode='' 321481 Init DB slznwl 321481 Query SELECT * FROM xycms_config LIMIT 1 321481 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321481 Query SELECT * FROM xycms_region WHERE `en`='wuzhou' 321481 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321481 Query Select * From xycms_sp 321481 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321481 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 321481 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 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321481 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 321481 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 321481 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321481 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 321481 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 321481 Query SELECT * FROM xycms_region 321481 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321481 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321481 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 321481 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 321481 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 321481 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 321481 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 321481 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 321481 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 321481 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 321481 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 321481 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 321481 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT a.*,z.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 321481 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321481 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 321481 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321481 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321481 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321481 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 321481 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 321481 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 321481 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 321481 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 321481 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321481 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321481 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321481 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 321481 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321481 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321481 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321481 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321481 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 321481 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321481 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321481 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='698' 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=54 321481 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc 321481 Query SELECT * FROM xycms_region 321481 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%自动化立体库%') and `id` <> 698 ORDER BY timeline DESC limit 10 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_region where flag=1 321481 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%自动化立体库%' ORDER BY timeline DESC limit 10 321482 Connect root@localhost on 321482 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321482 Query SET sql_mode='' 321482 Init DB slznwl 321482 Query SELECT * FROM xycms_config LIMIT 1 321482 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321481 Query SELECT orders FROM xycms_product where id='698' and flag=1 321481 Query SELECT id,title,orders FROM xycms_product WHERE orders > 462 AND cid=(SELECT cid FROM xycms_product WHERE id = 698) AND front=1 ORDER BY orders DESC 321481 Query SELECT orders FROM xycms_product where id='698' and flag=1 321481 Query SELECT id,title,orders FROM xycms_product WHERE orders < 462 AND cid=(SELECT cid FROM xycms_product WHERE id = 698) AND front=1 ORDER BY orders DESC 321481 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=54 321481 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=12 321481 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=12 321481 Query SELECT depth FROM xycms_productcate WHERE cid=12 321481 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=29 321481 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=57 321481 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=34 321481 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=35 321481 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=30 321481 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=33 321481 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=52 321481 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=32 321481 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=48 321481 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=53 321481 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=50 321481 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=54 321481 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=49 321481 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=36 321481 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=45 321481 Query SELECT depth FROM xycms_productcate WHERE cid=39 321481 Query SELECT depth FROM xycms_productcate WHERE cid=55 321481 Query SELECT depth FROM xycms_productcate WHERE cid=56 321481 Query SELECT depth FROM xycms_productcate WHERE cid=38 321481 Query SELECT depth FROM xycms_productcate WHERE cid=41 321481 Query SELECT depth FROM xycms_productcate WHERE cid=37 321481 Query SELECT depth FROM xycms_productcate WHERE cid=40 321481 Query SELECT depth FROM xycms_productcate WHERE cid=42 321481 Query SELECT depth FROM xycms_productcate WHERE cid=43 321481 Query SELECT depth FROM xycms_productcate WHERE cid=44 321481 Query SELECT depth FROM xycms_productcate WHERE cid=46 321481 Query SELECT depth FROM xycms_productcate WHERE cid=47 321481 Query SELECT depth FROM xycms_productcate WHERE cid=92 321481 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT depth FROM xycms_productcate WHERE cid=94 321481 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321481 Query SELECT banner,parentid FROM xycms_productcate where cid=54 321481 Query SELECT banner,parentid FROM xycms_productcate where cid=12 321482 Query SELECT * FROM xycms_region WHERE `en`='taizhou' 321482 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321482 Query Select * From xycms_sp 321482 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321482 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 321482 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 321483 Connect root@localhost on 321483 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321483 Query SET sql_mode='' 321483 Init DB slznwl 321482 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT * FROM xycms_region where flag=1 321481 Quit 321482 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321482 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 321483 Query SELECT * FROM xycms_config LIMIT 1 321483 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321482 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 321483 Query SELECT * FROM xycms_region WHERE `en`='zhuzhou' 321482 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321482 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 321483 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321482 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 321483 Query Select * From xycms_sp 321483 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321483 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 321483 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 321482 Query SELECT * FROM xycms_region 321482 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321483 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321483 Query SELECT * FROM xycms_region where flag=1 321482 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 321483 Query SELECT * FROM xycms_region where flag=1 321482 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 321482 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 321483 Query SELECT * FROM xycms_region where flag=1 321482 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 321483 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321482 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 321483 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 321482 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 321482 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 321482 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 321482 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 321482 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 321482 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321483 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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT a.*,z.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 321482 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321483 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321483 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 321483 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 321482 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 321482 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321482 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321482 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321482 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 321483 Query SELECT * FROM xycms_region 321483 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321483 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321483 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 321482 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 321483 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 321483 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 321483 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 321482 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 321483 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 321483 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 321483 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 321483 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 321482 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 321483 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 321482 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 321483 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 321482 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321483 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321482 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321482 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 321483 Query SELECT a.*,z.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 321482 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321482 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321483 Query SELECT a.*,z.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 321482 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 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT a.*,z.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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321483 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 321482 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321483 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321482 Query select cid from xycms_productcate where word='zxcbj667' 321483 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321482 Query SELECT * FROM xycms_productcate where cid='52' 321483 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 321482 Query SELECT cid FROM xycms_productcate WHERE parentid=52 321482 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='52' 321482 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='52' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 20 321483 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 321482 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT * FROM xycms_region where flag=1 321483 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 321482 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT * FROM xycms_region where flag=1 321483 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 321482 Query SELECT * FROM xycms_region where flag=1 321483 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 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321483 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321483 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 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321483 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321483 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 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query select * from xycms_productcate where cid ='52' LIMIT 1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE cid='52' LIMIT 1 321483 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=52 321483 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=52 321483 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=12 321483 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=12 321483 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=12 321483 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=29 321482 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=57 321483 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=34 321483 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=35 321483 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=30 321483 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=33 321483 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=52 321482 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=32 321483 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=48 321482 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=53 321483 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=50 321483 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=54 321483 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=49 321483 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=36 321483 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=45 321482 Query SELECT depth FROM xycms_productcate WHERE cid=39 321482 Query SELECT depth FROM xycms_productcate WHERE cid=55 321482 Query SELECT depth FROM xycms_productcate WHERE cid=56 321482 Query SELECT depth FROM xycms_productcate WHERE cid=38 321482 Query SELECT depth FROM xycms_productcate WHERE cid=41 321483 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='649' 321482 Query SELECT depth FROM xycms_productcate WHERE cid=37 321482 Query SELECT depth FROM xycms_productcate WHERE cid=40 321483 Query SELECT * FROM xycms_region where flag=1 321482 Query SELECT depth FROM xycms_productcate WHERE cid=42 321483 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=50 321482 Query SELECT depth FROM xycms_productcate WHERE cid=43 321483 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc 321482 Query SELECT depth FROM xycms_productcate WHERE cid=44 321482 Query SELECT depth FROM xycms_productcate WHERE cid=46 321482 Query SELECT depth FROM xycms_productcate WHERE cid=47 321483 Query SELECT * FROM xycms_region 321482 Query SELECT depth FROM xycms_productcate WHERE cid=92 321483 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%自动化立体库%') and `id` <> 649 ORDER BY timeline DESC limit 10 321482 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321482 Query SELECT depth FROM xycms_productcate WHERE cid=94 321482 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321482 Query SELECT banner,parentid FROM xycms_productcate where cid=52 321482 Query SELECT banner,parentid FROM xycms_productcate where cid=12 321483 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_region where flag=1 321483 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%自动化立体库%' ORDER BY timeline DESC limit 10 321482 Quit 321483 Query SELECT orders FROM xycms_product where id='649' and flag=1 321483 Query SELECT id,title,orders FROM xycms_product WHERE orders > 413 AND cid=(SELECT cid FROM xycms_product WHERE id = 649) AND front=1 ORDER BY orders DESC 321483 Query SELECT orders FROM xycms_product where id='649' and flag=1 321483 Query SELECT id,title,orders FROM xycms_product WHERE orders < 413 AND cid=(SELECT cid FROM xycms_product WHERE id = 649) AND front=1 ORDER BY orders DESC 321483 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=50 321483 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=12 321483 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=12 321483 Query SELECT depth FROM xycms_productcate WHERE cid=12 321483 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=29 321483 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=57 321483 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=34 321483 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=35 321483 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=30 321483 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=33 321483 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=52 321483 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=32 321483 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=48 321483 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=53 321483 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=50 321483 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=54 321483 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=49 321483 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=36 321483 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=45 321483 Query SELECT depth FROM xycms_productcate WHERE cid=39 321483 Query SELECT depth FROM xycms_productcate WHERE cid=55 321483 Query SELECT depth FROM xycms_productcate WHERE cid=56 321483 Query SELECT depth FROM xycms_productcate WHERE cid=38 321483 Query SELECT depth FROM xycms_productcate WHERE cid=41 321483 Query SELECT depth FROM xycms_productcate WHERE cid=37 321483 Query SELECT depth FROM xycms_productcate WHERE cid=40 321483 Query SELECT depth FROM xycms_productcate WHERE cid=42 321483 Query SELECT depth FROM xycms_productcate WHERE cid=43 321483 Query SELECT depth FROM xycms_productcate WHERE cid=44 321483 Query SELECT depth FROM xycms_productcate WHERE cid=46 321483 Query SELECT depth FROM xycms_productcate WHERE cid=47 321483 Query SELECT depth FROM xycms_productcate WHERE cid=92 321483 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT depth FROM xycms_productcate WHERE cid=94 321483 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321483 Query SELECT banner,parentid FROM xycms_productcate where cid=50 321483 Query SELECT banner,parentid FROM xycms_productcate where cid=12 321483 Quit 241022 15:06:51 321484 Connect root@localhost on 321484 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321484 Query SET sql_mode='' 321484 Init DB slznwl 321484 Query SELECT * FROM xycms_config LIMIT 1 321484 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321484 Query SELECT * FROM xycms_region WHERE `en`='taizhou' 321484 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321484 Query Select * From xycms_sp 321484 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321484 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 321484 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 321484 Query SELECT * FROM xycms_region where flag=1 321484 Query SELECT * FROM xycms_region where flag=1 321484 Query SELECT * FROM xycms_region where flag=1 321484 Query SELECT * FROM xycms_region where flag=1 321484 Query SELECT * FROM xycms_region where flag=1 321484 Query SELECT * FROM xycms_region where flag=1 321484 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321484 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 321484 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 321484 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321484 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 321484 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 321484 Query SELECT * FROM xycms_region 321484 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321484 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321484 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 321484 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 321484 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 321484 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 321484 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 321484 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 321484 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 321484 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 321484 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 321484 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 321484 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT a.*,z.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 321484 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321484 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 321484 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321484 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321484 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321484 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 321484 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 321484 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 321484 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 321484 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 321484 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321484 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321484 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321484 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 321484 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321484 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321484 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321484 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321484 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 321484 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321484 Query select cid from xycms_productcate where word='cpjbef' 321484 Query SELECT * FROM xycms_productcate where cid='81' 321484 Query SELECT cid FROM xycms_productcate WHERE parentid=81 321484 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='81' 321484 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='81' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 20 321484 Query SELECT * FROM xycms_region where flag=1 321484 Query select * from xycms_productcate where cid ='81' LIMIT 1 321484 Query SELECT * FROM xycms_region where flag=1 321484 Query SELECT * FROM xycms_productcate WHERE cid='81' LIMIT 1 321484 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=81 321484 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=81 321484 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=65 321484 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=65 321484 Query SELECT depth FROM xycms_productcate WHERE cid=65 321484 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=75 321484 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=76 321484 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=78 321484 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=79 321484 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=80 321484 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=81 321484 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=82 321484 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=83 321484 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=84 321484 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=86 321484 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT depth FROM xycms_productcate WHERE cid=87 321484 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321484 Query SELECT banner,parentid FROM xycms_productcate where cid=81 321484 Query SELECT banner,parentid FROM xycms_productcate where cid=65 321484 Quit 241022 15:07:45 321485 Connect root@localhost on 321485 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 321485 Query Set global general_log='on' 321485 Query select @@datadir 321485 Query Set global general_log_file='D:\\phpStudy\\WWW\\niu.php'