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 321894 Query SHOW TABLE STATUS FROM `#mysql50#hjttwjc#` LIKE 'xycms\_address%' 321894 Query SELECT COUNT(*) FROM `#mysql50#hjttwjc#`.`xycms_address` 321894 Quit 241022 15:38:23 321895 Connect root@localhost on 321895 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321895 Query SET sql_mode='' 321895 Init DB lfxkhk 321895 Query SELECT * FROM xycms_config LIMIT 1 321895 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321895 Query SELECT * FROM xycms_region WHERE `en`='shaoyang' 321895 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321895 Query Select * From xycms_sp 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=5 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 2 321895 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders ASC LIMIT 6 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 3 321895 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 321895 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 6 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 5 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=4 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 5 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=5 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 5 321895 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 2 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 8 321895 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders ASC LIMIT 6 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query Select v.*,c.cname,c.word From xycms_case As v Left Join xycms_casecate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.orders DESC LIMIT 10 321895 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 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=27 321895 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='27' ORDER BY v.orders DESC LIMIT 4 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=28 321895 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='28' ORDER BY v.orders DESC LIMIT 4 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=29 321895 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='29' ORDER BY v.orders DESC LIMIT 4 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=5 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='5' ORDER BY v.timeline DESC LIMIT 6 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 1 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='3' ORDER BY v.timeline DESC LIMIT 4 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=4 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 1 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=4 321895 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='4' ORDER BY v.timeline DESC LIMIT 6 321895 Query SELECT * FROM xycms_searchtype 321895 Query SELECT * FROM xycms_region ORDER BY orders ASC 321895 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321895 Query SELECT * FROM xycms_onlinechat WHERE flag=1 321895 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321895 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 321895 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 321895 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 321895 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC 321895 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.zonename,z.width,z.height FROM xycms_adsfigure AS a LEFT JOIN xycms_adszone AS z ON a.zoneid=z.zoneid WHERE a.zoneid='15' AND a.flag=1 ORDER BY a.orders ASC 321895 Query SELECT a.*,z.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 321895 Query SELECT a.*,z.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 321895 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321895 Query select id,groupid,username,loves,flag from xycms_user where username='' and password='' 321895 Query select id,groupid,username,loves,flag from xycms_user where username='' and password='' 321895 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 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321895 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321895 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321895 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 321896 Connect root@localhost on 321896 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321896 Query SET sql_mode='' 321896 Init DB slznwl 321895 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 321895 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 321895 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 321895 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321895 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3 321895 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=4 321895 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4 321895 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321895 Query SELECT cid FROM xycms_infocate WHERE parentid=5 321895 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=5 321895 Query SELECT * FROM xycms_infocate WHERE parentid=5 AND flag=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC 321895 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321895 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=1 321895 Query SELECT * FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321895 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321895 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321895 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321896 Query SELECT * FROM xycms_config LIMIT 1 321895 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5' 321895 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321896 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321895 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='5' LIMIT 10 321895 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 321895 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=68 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='51' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='52' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='53' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='54' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='55' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='56' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='57' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='58' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='59' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='60' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='61' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='62' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='63' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='64' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='65' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='66' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='67' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='68' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='69' LIMIT 10 321896 Query SELECT * FROM xycms_region WHERE `en`='ali' 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='70' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='71' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='72' LIMIT 10 321896 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='73' LIMIT 10 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='74' LIMIT 10 321896 Query Select * From xycms_sp 321895 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='75' LIMIT 10 321896 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321896 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 321895 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=51 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=51 321895 Query SELECT * FROM xycms_productcate WHERE parentid=51 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=52 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=52 321895 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321896 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 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=53 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=53 321895 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=54 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=54 321895 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=55 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=55 321895 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=56 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=56 321895 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=57 321896 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=57 321895 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=58 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=58 321895 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=59 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=59 321895 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=60 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=60 321896 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=61 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=61 321895 Query SELECT * FROM xycms_productcate WHERE parentid=61 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=62 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=62 321895 Query SELECT * FROM xycms_productcate WHERE parentid=62 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=63 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=63 321895 Query SELECT * FROM xycms_productcate WHERE parentid=63 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=64 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=64 321895 Query SELECT * FROM xycms_productcate WHERE parentid=64 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=65 321896 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=65 321895 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=66 321896 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 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=66 321895 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=67 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=67 321895 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=68 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=68 321895 Query SELECT * FROM xycms_productcate WHERE parentid=68 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=69 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=69 321895 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=70 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=70 321895 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=71 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=71 321895 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=72 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=72 321895 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=73 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=73 321895 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=74 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=74 321896 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 321895 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT cid FROM xycms_productcate WHERE parentid=75 321895 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=75 321895 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321895 Query SELECT * FROM xycms_region where flag=1 321895 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='1106' 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=67 321895 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc 241022 15:38:24 321895 Query SELECT * FROM xycms_region ORDER BY orders ASC 321895 Query select id,groupid,username,loves,flag from xycms_user where username='' and password='' 321895 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%飞机应急设备示教板%' or tag like '%%' or tag like '%%') and `id` <> 1106 ORDER BY timeline DESC limit 10 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_region where flag=1 321895 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%飞机应急设备示教板%' or tag like '%%' or tag like '%%' ORDER BY timeline DESC limit 10 321896 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321896 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 321896 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 321896 Query SELECT * FROM xycms_region 321896 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321895 Query SELECT orders FROM xycms_product where id='1106' and flag=1 321895 Query SELECT id,title,orders FROM xycms_product WHERE orders > 334 AND cid=(SELECT cid FROM xycms_product WHERE id = 1106) AND front=1 ORDER BY orders DESC 321895 Query SELECT orders FROM xycms_product where id='1106' and flag=1 321895 Query SELECT id,title,orders FROM xycms_product WHERE orders < 334 AND cid=(SELECT cid FROM xycms_product WHERE id = 1106) AND front=1 ORDER BY orders DESC 321895 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=67 321895 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=67 321895 Query SELECT depth FROM xycms_productcate WHERE cid=67 321895 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321895 Query SELECT banner,parentid FROM xycms_productcate where cid=67 321896 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321896 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 321896 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 321896 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 321896 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 321896 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 321896 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 321896 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 321896 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 321896 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 321896 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 321896 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321895 Quit 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT a.*,z.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 321896 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321896 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 321896 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321896 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321896 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321896 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 321896 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 321896 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 321896 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 321896 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 321896 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321896 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321896 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321896 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 321896 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321896 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321896 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321896 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321896 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 321896 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321896 Query select cid from xycms_productcate where word='ckglrjxtddb' 321896 Query SELECT * FROM xycms_productcate where cid='69' 321896 Query SELECT cid FROM xycms_productcate WHERE parentid=69 321896 Query SELECT cid FROM xycms_productcate WHERE parentid=70 321896 Query SELECT cid FROM xycms_productcate WHERE parentid=71 321896 Query SELECT cid FROM xycms_productcate WHERE parentid=72 321896 Query SELECT cid FROM xycms_productcate WHERE parentid=73 321896 Query SELECT cid FROM xycms_productcate WHERE parentid=74 321896 Query SELECT cid FROM xycms_productcate WHERE parentid=88 321896 Query SELECT cid FROM xycms_productcate WHERE parentid=85 321896 Query SELECT cid FROM xycms_productcate WHERE parentid=89 321896 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND (v.cid='69' OR v.cid=70 OR v.cid=71 OR v.cid=72 OR v.cid=73 OR v.cid=74 OR v.cid=88 OR v.cid=85 OR v.cid=89) 321896 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='69' OR v.cid=70 OR v.cid=71 OR v.cid=72 OR v.cid=73 OR v.cid=74 OR v.cid=88 OR v.cid=85 OR v.cid=89) AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 20 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query select * from xycms_productcate where cid ='69' LIMIT 1 321896 Query SELECT * FROM xycms_region where flag=1 321896 Query SELECT * FROM xycms_productcate WHERE cid='69' LIMIT 1 321896 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=69 321896 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=69 321896 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=69 321896 Query SELECT depth FROM xycms_productcate WHERE cid=69 321896 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321896 Query SELECT depth FROM xycms_productcate WHERE cid=70 321896 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321896 Query SELECT depth FROM xycms_productcate WHERE cid=71 321896 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321896 Query SELECT depth FROM xycms_productcate WHERE cid=72 321896 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321896 Query SELECT depth FROM xycms_productcate WHERE cid=73 321896 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321896 Query SELECT depth FROM xycms_productcate WHERE cid=74 321896 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321896 Query SELECT depth FROM xycms_productcate WHERE cid=85 321896 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321896 Query SELECT depth FROM xycms_productcate WHERE cid=88 321896 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321896 Query SELECT depth FROM xycms_productcate WHERE cid=89 321896 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321896 Query SELECT banner,parentid FROM xycms_productcate where cid=69 321896 Quit 241022 15:38:25 321897 Connect root@localhost on 321897 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321897 Query SET sql_mode='' 321897 Init DB slznwl 321897 Query SELECT * FROM xycms_config LIMIT 1 321897 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321897 Query SELECT * FROM xycms_region WHERE `en`='donggang' 321897 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321897 Query Select * From xycms_sp 321897 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321897 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 321897 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 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321897 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 321897 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 321897 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321897 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 321897 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 321897 Query SELECT * FROM xycms_region 321897 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321897 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321897 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 321897 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 321897 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 321897 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 321897 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 321897 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 321897 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 321897 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 321897 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 321897 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 321897 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT a.*,z.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 321897 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321897 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 321897 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321897 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321897 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321897 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 321897 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 321897 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 321897 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 321897 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 321897 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321897 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321897 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321897 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 321897 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321897 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321897 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321897 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321897 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 321897 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321897 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321897 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='852' 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=94 321897 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc 321897 Query SELECT * FROM xycms_region 321897 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%横梁式货架%') and `id` <> 852 ORDER BY timeline DESC limit 10 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT * FROM xycms_region where flag=1 321897 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%横梁式货架%' ORDER BY timeline DESC limit 10 321897 Query SELECT orders FROM xycms_product where id='852' and flag=1 321897 Query SELECT id,title,orders FROM xycms_product WHERE orders > 618 AND cid=(SELECT cid FROM xycms_product WHERE id = 852) AND front=1 ORDER BY orders DESC 321897 Query SELECT orders FROM xycms_product where id='852' and flag=1 321897 Query SELECT id,title,orders FROM xycms_product WHERE orders < 618 AND cid=(SELECT cid FROM xycms_product WHERE id = 852) AND front=1 ORDER BY orders DESC 321897 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=94 321897 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=12 321897 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=12 321897 Query SELECT depth FROM xycms_productcate WHERE cid=12 321897 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=29 321897 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=57 321897 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=34 321897 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=35 321897 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=30 321897 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=33 321897 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=52 321897 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=32 321897 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=48 321897 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=53 321897 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=50 321897 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=54 321897 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=49 321897 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=36 321897 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=45 321897 Query SELECT depth FROM xycms_productcate WHERE cid=39 321897 Query SELECT depth FROM xycms_productcate WHERE cid=55 321897 Query SELECT depth FROM xycms_productcate WHERE cid=56 321897 Query SELECT depth FROM xycms_productcate WHERE cid=38 321897 Query SELECT depth FROM xycms_productcate WHERE cid=41 321897 Query SELECT depth FROM xycms_productcate WHERE cid=37 321897 Query SELECT depth FROM xycms_productcate WHERE cid=40 321897 Query SELECT depth FROM xycms_productcate WHERE cid=42 321897 Query SELECT depth FROM xycms_productcate WHERE cid=43 321897 Query SELECT depth FROM xycms_productcate WHERE cid=44 321897 Query SELECT depth FROM xycms_productcate WHERE cid=46 321897 Query SELECT depth FROM xycms_productcate WHERE cid=47 321897 Query SELECT depth FROM xycms_productcate WHERE cid=92 321897 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT depth FROM xycms_productcate WHERE cid=94 321897 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321897 Query SELECT banner,parentid FROM xycms_productcate where cid=94 321897 Query SELECT banner,parentid FROM xycms_productcate where cid=12 321897 Quit 241022 15:38:26 321898 Connect root@localhost on 321898 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321898 Query SET sql_mode='' 321898 Init DB slznwl 321898 Query SELECT * FROM xycms_config LIMIT 1 321898 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321898 Query SELECT * FROM xycms_region WHERE `en`='fuqing' 321898 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321898 Query Select * From xycms_sp 321898 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321898 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 321898 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 321898 Query SELECT * FROM xycms_region where flag=1 321898 Query SELECT * FROM xycms_region where flag=1 321898 Query SELECT * FROM xycms_region where flag=1 321898 Query SELECT * FROM xycms_region where flag=1 321898 Query SELECT * FROM xycms_region where flag=1 321898 Query SELECT * FROM xycms_region where flag=1 321898 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321898 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 321898 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 321898 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321898 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 321898 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 321898 Query SELECT * FROM xycms_region 321898 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321898 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321898 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 321898 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 321898 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 321898 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 321898 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 321898 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 321898 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 321898 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 321898 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 321898 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 321898 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT a.*,z.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 321898 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321898 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 321898 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321898 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321898 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321898 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 321898 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 321898 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 321898 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 321898 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 321898 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321898 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321898 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321898 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 321898 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321898 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321898 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321898 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321898 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 321898 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321898 Query select cid from xycms_productcate where word='RFsczdxt74c' 321898 Query SELECT * FROM xycms_productcate where cid='73' 321898 Query SELECT cid FROM xycms_productcate WHERE parentid=73 321898 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='73' 321898 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='73' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 20 321898 Query SELECT * FROM xycms_region where flag=1 321898 Query select * from xycms_productcate where cid ='73' LIMIT 1 321898 Query SELECT * FROM xycms_region where flag=1 321898 Query SELECT * FROM xycms_productcate WHERE cid='73' LIMIT 1 321898 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=73 321898 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=73 321898 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=69 321898 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=69 321898 Query SELECT depth FROM xycms_productcate WHERE cid=69 321898 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321898 Query SELECT depth FROM xycms_productcate WHERE cid=70 321898 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321898 Query SELECT depth FROM xycms_productcate WHERE cid=71 321898 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321898 Query SELECT depth FROM xycms_productcate WHERE cid=72 321898 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321898 Query SELECT depth FROM xycms_productcate WHERE cid=73 321898 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321898 Query SELECT depth FROM xycms_productcate WHERE cid=74 321898 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321898 Query SELECT depth FROM xycms_productcate WHERE cid=85 321898 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321898 Query SELECT depth FROM xycms_productcate WHERE cid=88 321898 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321898 Query SELECT depth FROM xycms_productcate WHERE cid=89 321898 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321898 Query SELECT banner,parentid FROM xycms_productcate where cid=73 321898 Query SELECT banner,parentid FROM xycms_productcate where cid=69 321898 Quit 241022 15:38:28 321899 Connect root@localhost on 321899 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321899 Query SET sql_mode='' 321899 Init DB slznwl 321899 Query SELECT * FROM xycms_config LIMIT 1 321899 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321899 Query SELECT * FROM xycms_region WHERE `en`='guilin' 321899 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321899 Query Select * From xycms_sp 321899 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321899 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 321899 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 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321899 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 321899 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 321899 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321899 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 321899 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 321899 Query SELECT * FROM xycms_region 321899 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321899 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321899 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 321899 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 321899 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 321899 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 321899 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 321899 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 321899 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 321899 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 321899 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 321899 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 321899 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT a.*,z.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 321899 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321899 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 321899 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321899 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321899 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321899 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 321899 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 321899 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 321899 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 321899 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 321899 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321899 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321899 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321899 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 321899 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321899 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321899 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321899 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321899 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 321899 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321899 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321899 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='684' 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=66 321899 Query SELECT * FROM xycms_region 321899 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%自动化立体库%') and `id` <> 684 ORDER BY timeline DESC limit 10 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_region where flag=1 321899 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%自动化立体库%' ORDER BY timeline DESC limit 10 321899 Query SELECT orders FROM xycms_product where id='684' and flag=1 321899 Query SELECT id,title,orders FROM xycms_product WHERE orders > 448 AND cid=(SELECT cid FROM xycms_product WHERE id = 684) AND front=1 ORDER BY orders DESC 321899 Query SELECT orders FROM xycms_product where id='684' and flag=1 321899 Query SELECT id,title,orders FROM xycms_product WHERE orders < 448 AND cid=(SELECT cid FROM xycms_product WHERE id = 684) AND front=1 ORDER BY orders DESC 321899 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=66 321899 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=66 321899 Query SELECT depth FROM xycms_productcate WHERE cid=66 321899 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321899 Query SELECT banner,parentid FROM xycms_productcate where cid=66 321899 Quit 321900 Connect root@localhost on 321900 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321900 Query SET sql_mode='' 321900 Init DB slznwl 321900 Query SELECT * FROM xycms_config LIMIT 1 321900 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321900 Query SELECT * FROM xycms_region WHERE `en`='penglai' 321900 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321900 Query Select * From xycms_sp 321900 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321900 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 321900 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 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321900 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 321900 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 321900 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321900 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 321900 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 321900 Query SELECT * FROM xycms_region 321900 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321900 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321900 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 321900 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 321900 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 321900 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 321900 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 321900 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 321900 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 321900 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 321900 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 321900 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 321900 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT a.*,z.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 321900 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321900 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 321900 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321900 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321900 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321900 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 321900 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 321900 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 321900 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 321900 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 321900 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321900 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321900 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321900 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 321900 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321900 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321900 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321900 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321900 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 321900 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321900 Query select cid from xycms_productcate where word='srsaf3' 321900 Query SELECT * FROM xycms_productcate where cid='34' 321900 Query SELECT cid FROM xycms_productcate WHERE parentid=34 321900 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='34' 321900 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='34' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 20 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query select * from xycms_productcate where cid ='34' LIMIT 1 321900 Query SELECT * FROM xycms_region where flag=1 321900 Query SELECT * FROM xycms_productcate WHERE cid='34' LIMIT 1 321900 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=34 321900 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=34 321900 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=12 321900 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=12 321900 Query SELECT depth FROM xycms_productcate WHERE cid=12 321900 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=29 321900 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=57 321900 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=34 321900 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=35 321900 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=30 321900 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=33 321900 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=52 321900 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=32 321900 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=48 321900 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=53 321900 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=50 321900 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=54 321900 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=49 321900 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=36 321900 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=45 321900 Query SELECT depth FROM xycms_productcate WHERE cid=39 321900 Query SELECT depth FROM xycms_productcate WHERE cid=55 321900 Query SELECT depth FROM xycms_productcate WHERE cid=56 321900 Query SELECT depth FROM xycms_productcate WHERE cid=38 321900 Query SELECT depth FROM xycms_productcate WHERE cid=41 321900 Query SELECT depth FROM xycms_productcate WHERE cid=37 321900 Query SELECT depth FROM xycms_productcate WHERE cid=40 321900 Query SELECT depth FROM xycms_productcate WHERE cid=42 321900 Query SELECT depth FROM xycms_productcate WHERE cid=43 321900 Query SELECT depth FROM xycms_productcate WHERE cid=44 321900 Query SELECT depth FROM xycms_productcate WHERE cid=46 321900 Query SELECT depth FROM xycms_productcate WHERE cid=47 321900 Query SELECT depth FROM xycms_productcate WHERE cid=92 321900 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT depth FROM xycms_productcate WHERE cid=94 321900 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321900 Query SELECT banner,parentid FROM xycms_productcate where cid=34 321900 Query SELECT banner,parentid FROM xycms_productcate where cid=12 321900 Quit 241022 15:38:29 321901 Connect root@localhost on 321901 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321901 Query SET sql_mode='' 321901 Init DB slznwl 321901 Query SELECT * FROM xycms_config LIMIT 1 321901 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321901 Query SELECT * FROM xycms_region WHERE `en`='tongzhou' 321901 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321901 Query Select * From xycms_sp 321901 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321901 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 321901 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 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321901 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 321901 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 321901 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321901 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 321901 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 321901 Query SELECT * FROM xycms_region 321901 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321901 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321901 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 321901 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 321901 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 321901 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 321901 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 321901 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 321901 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 321901 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 321901 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 241022 15:38:30 321901 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 321901 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT a.*,z.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 321901 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321901 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 321901 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321901 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321901 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321901 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 321901 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 321901 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 321901 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 321901 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 321901 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321901 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321901 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321901 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 321901 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321901 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321901 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321901 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321901 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 321901 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321901 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321901 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='628' 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=75 321901 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc 321901 Query SELECT * FROM xycms_region 321901 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%立体库%') and `id` <> 628 ORDER BY timeline DESC limit 10 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_region where flag=1 321901 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%立体库%' ORDER BY timeline DESC limit 10 321901 Query SELECT orders FROM xycms_product where id='628' and flag=1 321901 Query SELECT id,title,orders FROM xycms_product WHERE orders > 392 AND cid=(SELECT cid FROM xycms_product WHERE id = 628) AND front=1 ORDER BY orders DESC 321901 Query SELECT orders FROM xycms_product where id='628' and flag=1 321901 Query SELECT id,title,orders FROM xycms_product WHERE orders < 392 AND cid=(SELECT cid FROM xycms_product WHERE id = 628) AND front=1 ORDER BY orders DESC 321901 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=75 321901 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=65 321901 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=65 321901 Query SELECT depth FROM xycms_productcate WHERE cid=65 321901 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=75 321901 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=76 321901 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=78 321901 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=79 321901 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=80 321901 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=81 321901 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=82 321901 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=83 321901 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=84 321901 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=86 321901 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT depth FROM xycms_productcate WHERE cid=87 321901 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321901 Query SELECT banner,parentid FROM xycms_productcate where cid=75 321901 Query SELECT banner,parentid FROM xycms_productcate where cid=65 321901 Quit 241022 15:38:31 321902 Connect root@localhost on 321902 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321902 Query SET sql_mode='' 321902 Init DB slznwl 321902 Query SELECT * FROM xycms_config LIMIT 1 321902 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321902 Query SELECT hits FROM xycms_product WHERE id='852' 321902 Query UPDATE xycms_product SET hits=hits+1 WHERE id='852' 321902 Quit 321903 Connect root@localhost on 321903 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321903 Query SET sql_mode='' 321903 Init DB syzzrs 321903 Query SELECT * FROM xycms_config LIMIT 1 321903 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321903 Query SELECT * FROM xycms_region WHERE `en`='jiagedaqi' 321903 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321903 Query Select * From xycms_sp 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=1 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=54 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=45 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=48 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=49 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=50 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=51 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=52 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=53 321903 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='1' OR v.cid=54 OR v.cid=45 OR v.cid=48 OR v.cid=49 OR v.cid=50 OR v.cid=51 OR v.cid=52 OR v.cid=53) ORDER BY v.timeline DESC LIMIT 6 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 3 321903 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' ORDER BY v.timeline DESC LIMIT 3 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=2 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=12 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=25 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=26 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=27 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=28 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=29 321903 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='2' OR v.cid=12 OR v.cid=25 OR v.cid=26 OR v.cid=27 OR v.cid=28 OR v.cid=29) ORDER BY v.timeline DESC LIMIT 6 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=3 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=15 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=43 321903 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='3' OR v.cid=15 OR v.cid=43) ORDER BY v.timeline DESC LIMIT 6 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=4 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=19 321903 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='4' OR v.cid=19) ORDER BY v.timeline DESC LIMIT 6 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=20 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=21 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=60 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=69 321903 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='20' OR v.cid=21 OR v.cid=60 OR v.cid=69) ORDER BY v.timeline DESC LIMIT 6 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=22 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=46 321903 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='22' OR v.cid=46) ORDER BY v.timeline DESC LIMIT 6 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=44 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=58 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=57 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=56 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=55 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=47 321903 Query SELECT cid FROM xycms_productcate WHERE parentid=59 321903 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='44' OR v.cid=58 OR v.cid=57 OR v.cid=56 OR v.cid=55 OR v.cid=47 OR v.cid=59) ORDER BY v.timeline DESC LIMIT 6 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region 321903 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321903 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321903 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 321903 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 321903 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 321903 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=14 AND v.flag=1 ORDER BY v.orders ASC 321903 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC 321903 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321903 Query SELECT a.*,z.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 321903 Query SELECT a.*,z.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 321903 Query SELECT a.*,z.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 321903 Query SELECT a.*,z.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 321903 Query SELECT a.*,z.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 321903 Query SELECT a.*,z.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 321903 Query SELECT a.*,z.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 321903 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321903 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 321903 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321903 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321903 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321903 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 321903 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 321903 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 321903 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 321903 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 321903 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321903 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321903 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321903 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 321903 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321903 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321903 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321903 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 321903 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321903 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC 321903 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='439' 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=51 321903 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc 321903 Query SELECT * FROM xycms_region 321903 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%   小区健身器材%' or tag like '%小区健身器材价格%' or tag like '%小区健身器材批发%') and `id` <> 439 ORDER BY timeline DESC limit 10 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_region where flag=1 321903 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%   小区健身器材%' or tag like '%小区健身器材价格%' or tag like '%小区健身器材批发%' ORDER BY timeline DESC limit 10 321903 Query SELECT orders FROM xycms_product where id='439' and flag=1 321903 Query SELECT id,title,orders FROM xycms_product WHERE orders > 240 AND cid=(SELECT cid FROM xycms_product WHERE id = 439) AND front=1 ORDER BY orders DESC 321903 Query SELECT orders FROM xycms_product where id='439' and flag=1 321903 Query SELECT id,title,orders FROM xycms_product WHERE orders < 240 AND cid=(SELECT cid FROM xycms_product WHERE id = 439) AND front=1 ORDER BY orders DESC 321903 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=51 321903 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=45 321903 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=1 321903 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=1 321903 Query SELECT depth FROM xycms_productcate WHERE cid=1 321903 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321903 Query SELECT depth FROM xycms_productcate WHERE cid=45 321903 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321903 Query SELECT depth FROM xycms_productcate WHERE cid=48 321903 Query SELECT depth FROM xycms_productcate WHERE cid=49 321903 Query SELECT depth FROM xycms_productcate WHERE cid=50 321903 Query SELECT depth FROM xycms_productcate WHERE cid=51 321903 Query SELECT depth FROM xycms_productcate WHERE cid=52 321903 Query SELECT depth FROM xycms_productcate WHERE cid=53 321903 Query SELECT depth FROM xycms_productcate WHERE cid=54 321903 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321903 Quit 241022 15:38:33 321904 Connect root@localhost on 321904 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321904 Query SET sql_mode='' 321904 Init DB slznwl 321904 Query SELECT * FROM xycms_config LIMIT 1 321904 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321904 Query SELECT * FROM xycms_region WHERE `en`='linxia' 321904 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321904 Query Select * From xycms_sp 321904 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321904 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 321904 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 321904 Query SELECT * FROM xycms_region where flag=1 321904 Query SELECT * FROM xycms_region where flag=1 321904 Query SELECT * FROM xycms_region where flag=1 321904 Query SELECT * FROM xycms_region where flag=1 321904 Query SELECT * FROM xycms_region where flag=1 321904 Query SELECT * FROM xycms_region where flag=1 321904 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321904 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 321904 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 321904 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321904 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 321904 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 321904 Query SELECT * FROM xycms_region 321904 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321904 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321904 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 321904 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 321904 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 321904 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 321904 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 321904 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 321904 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 321904 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 321904 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 321904 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 321904 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT a.*,z.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 321904 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321904 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 321904 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321904 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321904 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321904 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 321904 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 321904 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 321904 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 321904 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 321904 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321904 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321904 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321904 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 321904 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321904 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321904 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321904 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321904 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 321904 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321904 Query select cid from xycms_productcate where word='AGVznglxt4e1' 321904 Query SELECT * FROM xycms_productcate where cid='88' 321904 Query SELECT cid FROM xycms_productcate WHERE parentid=88 321904 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='88' 321904 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='88' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 20 321904 Query SELECT * FROM xycms_region where flag=1 321904 Query select * from xycms_productcate where cid ='88' LIMIT 1 321904 Query SELECT * FROM xycms_region where flag=1 321904 Query SELECT * FROM xycms_productcate WHERE cid='88' LIMIT 1 321904 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=88 321904 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=88 321904 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=69 321904 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=69 321904 Query SELECT depth FROM xycms_productcate WHERE cid=69 321904 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321904 Query SELECT depth FROM xycms_productcate WHERE cid=70 321904 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321904 Query SELECT depth FROM xycms_productcate WHERE cid=71 321904 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321904 Query SELECT depth FROM xycms_productcate WHERE cid=72 321904 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321904 Query SELECT depth FROM xycms_productcate WHERE cid=73 321904 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321904 Query SELECT depth FROM xycms_productcate WHERE cid=74 321904 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321904 Query SELECT depth FROM xycms_productcate WHERE cid=85 321904 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321904 Query SELECT depth FROM xycms_productcate WHERE cid=88 321904 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321904 Query SELECT depth FROM xycms_productcate WHERE cid=89 321904 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321904 Query SELECT banner,parentid FROM xycms_productcate where cid=88 321904 Query SELECT banner,parentid FROM xycms_productcate where cid=69 321904 Quit 241022 15:38:34 321905 Connect root@localhost on 321905 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321905 Query SET sql_mode='' 321905 Init DB slznwl 321905 Query SELECT * FROM xycms_config LIMIT 1 321905 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321905 Query SELECT * FROM xycms_region WHERE `en`='huaibei' 321905 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321905 Query Select * From xycms_sp 321905 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321905 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 321905 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 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321905 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 321905 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 321905 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321905 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 321905 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 321905 Query SELECT * FROM xycms_region 321905 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321905 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321905 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 321905 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 321905 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 321905 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 321905 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 321905 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 321905 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 321905 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 321905 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 321905 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 321905 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT a.*,z.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 321905 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321905 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 321905 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321905 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321905 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321905 Query SELECT v.*,c.cname,c.catdir FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.flag=1 AND `catdir`='' ORDER BY c.cid,v.orders 241022 15:38:35 321905 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 321905 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 321905 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 321905 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 321905 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321905 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321905 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321905 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 321905 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321905 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321905 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321905 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321905 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 321905 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321905 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321905 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='692' 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=34 321905 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc 321905 Query SELECT * FROM xycms_region 321905 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%立体库%') and `id` <> 692 ORDER BY timeline DESC limit 10 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_region where flag=1 321905 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%立体库%' ORDER BY timeline DESC limit 10 321905 Query SELECT orders FROM xycms_product where id='692' and flag=1 321905 Query SELECT id,title,orders FROM xycms_product WHERE orders > 456 AND cid=(SELECT cid FROM xycms_product WHERE id = 692) AND front=1 ORDER BY orders DESC 321905 Query SELECT orders FROM xycms_product where id='692' and flag=1 321905 Query SELECT id,title,orders FROM xycms_product WHERE orders < 456 AND cid=(SELECT cid FROM xycms_product WHERE id = 692) AND front=1 ORDER BY orders DESC 321905 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=34 321905 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=12 321905 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=12 321905 Query SELECT depth FROM xycms_productcate WHERE cid=12 321905 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=29 321905 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=57 321905 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=34 321905 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=35 321905 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=30 321905 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=33 321905 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=52 321905 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=32 321905 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=48 321905 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=53 321905 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=50 321905 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=54 321905 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=49 321905 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=36 321905 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=45 321905 Query SELECT depth FROM xycms_productcate WHERE cid=39 321905 Query SELECT depth FROM xycms_productcate WHERE cid=55 321905 Query SELECT depth FROM xycms_productcate WHERE cid=56 321905 Query SELECT depth FROM xycms_productcate WHERE cid=38 321905 Query SELECT depth FROM xycms_productcate WHERE cid=41 321905 Query SELECT depth FROM xycms_productcate WHERE cid=37 321905 Query SELECT depth FROM xycms_productcate WHERE cid=40 321905 Query SELECT depth FROM xycms_productcate WHERE cid=42 321905 Query SELECT depth FROM xycms_productcate WHERE cid=43 321905 Query SELECT depth FROM xycms_productcate WHERE cid=44 321905 Query SELECT depth FROM xycms_productcate WHERE cid=46 321905 Query SELECT depth FROM xycms_productcate WHERE cid=47 321905 Query SELECT depth FROM xycms_productcate WHERE cid=92 321905 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT depth FROM xycms_productcate WHERE cid=94 321905 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321905 Query SELECT banner,parentid FROM xycms_productcate where cid=34 321905 Query SELECT banner,parentid FROM xycms_productcate where cid=12 321905 Quit 241022 15:38:36 321906 Connect root@localhost on 321906 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321906 Query SET sql_mode='' 321906 Init DB slznwl 321906 Query SELECT * FROM xycms_config LIMIT 1 321906 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321906 Query SELECT * FROM xycms_region WHERE `en`='huayin' 321906 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321906 Query Select * From xycms_sp 321906 Query SELECT cid FROM xycms_infocate WHERE parentid=1 321906 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 321906 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 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT cid FROM xycms_infocate WHERE parentid=3 321906 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 321906 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 321906 Query SELECT cid FROM xycms_casecate WHERE parentid=1 321906 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 321906 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 321906 Query SELECT * FROM xycms_region 321906 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321906 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321906 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 321906 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 321906 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 321906 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 321906 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 321906 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 321906 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 321906 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 321906 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 321906 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 321906 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT a.*,z.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 321906 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321906 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 321906 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321906 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321906 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321906 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 321906 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 321906 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 321906 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 321906 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 321906 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321906 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321906 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321906 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 321906 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321906 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 321906 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321906 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321906 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 321906 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=65 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=78 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=79 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=80 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=81 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=82 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=83 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=84 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=86 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=87 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=66 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=67 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=69 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=70 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=71 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=72 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=73 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=85 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=88 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=89 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=90 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=91 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query SELECT * FROM xycms_productcate WHERE parentid=93 AND flag=1 AND front=1 ORDER BY orders ASC 321906 Query select cid from xycms_productcate where word='llja2f' 321906 Query SELECT * FROM xycms_productcate where cid='32' 321906 Query SELECT cid FROM xycms_productcate WHERE parentid=32 321906 Query SELECT COUNT(v.id) FROM xycms_product AS v WHERE v.flag=1 AND v.cid='32' 321906 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='32' AND v.front=1 AND c.front=1 ORDER BY v.orders DESC LIMIT 0, 20 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query select * from xycms_productcate where cid ='32' LIMIT 1 321906 Query SELECT * FROM xycms_region where flag=1 321906 Query SELECT * FROM xycms_productcate WHERE cid='32' LIMIT 1 321906 Query SELECT `intro` FROM xycms_productcate where flag=1 and cid=32 321906 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=32 321906 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=12 321906 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=12 321906 Query SELECT depth FROM xycms_productcate WHERE cid=12 321906 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=29 321906 Query SELECT * FROM xycms_productcate WHERE parentid=29 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=57 321906 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=34 321906 Query SELECT * FROM xycms_productcate WHERE parentid=34 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=35 321906 Query SELECT * FROM xycms_productcate WHERE parentid=35 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=30 321906 Query SELECT * FROM xycms_productcate WHERE parentid=30 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=33 321906 Query SELECT * FROM xycms_productcate WHERE parentid=33 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=52 321906 Query SELECT * FROM xycms_productcate WHERE parentid=52 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=32 321906 Query SELECT * FROM xycms_productcate WHERE parentid=32 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=48 321906 Query SELECT * FROM xycms_productcate WHERE parentid=48 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=53 321906 Query SELECT * FROM xycms_productcate WHERE parentid=53 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=50 321906 Query SELECT * FROM xycms_productcate WHERE parentid=50 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=54 321906 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=49 321906 Query SELECT * FROM xycms_productcate WHERE parentid=49 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=36 321906 Query SELECT * FROM xycms_productcate WHERE parentid=36 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=45 321906 Query SELECT depth FROM xycms_productcate WHERE cid=39 321906 Query SELECT depth FROM xycms_productcate WHERE cid=55 321906 Query SELECT depth FROM xycms_productcate WHERE cid=56 321906 Query SELECT depth FROM xycms_productcate WHERE cid=38 321906 Query SELECT depth FROM xycms_productcate WHERE cid=41 321906 Query SELECT depth FROM xycms_productcate WHERE cid=37 321906 Query SELECT depth FROM xycms_productcate WHERE cid=40 321906 Query SELECT depth FROM xycms_productcate WHERE cid=42 321906 Query SELECT depth FROM xycms_productcate WHERE cid=43 321906 Query SELECT depth FROM xycms_productcate WHERE cid=44 321906 Query SELECT depth FROM xycms_productcate WHERE cid=46 321906 Query SELECT depth FROM xycms_productcate WHERE cid=47 321906 Query SELECT depth FROM xycms_productcate WHERE cid=92 321906 Query SELECT * FROM xycms_productcate WHERE parentid=92 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT depth FROM xycms_productcate WHERE cid=94 321906 Query SELECT * FROM xycms_productcate WHERE parentid=94 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321906 Query SELECT banner,parentid FROM xycms_productcate where cid=32 321906 Query SELECT banner,parentid FROM xycms_productcate where cid=12 321906 Quit 241022 15:38:40 321907 Connect root@localhost on 321907 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 321907 Init DB #mysql50#hjttwjc# 321907 Init DB #mysql50#hjttwjc# 321907 Query SELECT '' 321907 Query SHOW TABLE STATUS FROM `#mysql50#hjttwjc#` LIKE 'xycms\_address%' 321907 Query SELECT COUNT(*) FROM `#mysql50#hjttwjc#`.`xycms_address` 321907 Query SHOW CREATE TABLE `#mysql50#hjttwjc#`.`xycms_address` 321907 Quit 241022 15:38:42 321908 Connect root@localhost on 321908 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 321908 Query SET sql_mode='' 321908 Init DB syzzrs 321908 Query SELECT * FROM xycms_config LIMIT 1 321908 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 321908 Query SELECT * FROM xycms_region WHERE `en`='shenyang' 321908 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 321908 Query Select * From xycms_sp 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=1 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=54 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=45 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=48 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=49 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=50 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=51 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=52 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=53 321908 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='1' OR v.cid=54 OR v.cid=45 OR v.cid=48 OR v.cid=49 OR v.cid=50 OR v.cid=51 OR v.cid=52 OR v.cid=53) ORDER BY v.timeline DESC LIMIT 6 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' ORDER BY v.timeline DESC LIMIT 3 321908 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.elite='1' ORDER BY v.timeline DESC LIMIT 3 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=2 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=12 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=25 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=26 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=27 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=28 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=29 321908 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='2' OR v.cid=12 OR v.cid=25 OR v.cid=26 OR v.cid=27 OR v.cid=28 OR v.cid=29) ORDER BY v.timeline DESC LIMIT 6 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=3 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=15 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=43 321908 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='3' OR v.cid=15 OR v.cid=43) ORDER BY v.timeline DESC LIMIT 6 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=4 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=19 321908 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='4' OR v.cid=19) ORDER BY v.timeline DESC LIMIT 6 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=20 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=21 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=60 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=69 321908 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='20' OR v.cid=21 OR v.cid=60 OR v.cid=69) ORDER BY v.timeline DESC LIMIT 6 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=22 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=46 321908 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='22' OR v.cid=46) ORDER BY v.timeline DESC LIMIT 6 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=44 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=58 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=57 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=56 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=55 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=47 321908 Query SELECT cid FROM xycms_productcate WHERE parentid=59 321908 Query Select v.*,c.cname,c.word From xycms_product As v Left Join xycms_productcate As c On v.cid=c.cid Where v.flag = '1' AND (v.cid='44' OR v.cid=58 OR v.cid=57 OR v.cid=56 OR v.cid=55 OR v.cid=47 OR v.cid=59) ORDER BY v.timeline DESC LIMIT 6 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region 321908 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 321908 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 321908 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 321908 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 321908 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 321908 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=14 AND v.flag=1 ORDER BY v.orders ASC 321908 Query SELECT v.*,c.cname FROM xycms_page AS v LEFT JOIN xycms_pagecate AS c ON v.cid=c.cid WHERE v.cid=15 AND v.flag=1 ORDER BY v.orders ASC 321908 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 321908 Query SELECT a.*,z.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 321908 Query SELECT a.*,z.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 321908 Query SELECT a.*,z.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 321908 Query SELECT a.*,z.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 321908 Query SELECT a.*,z.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 321908 Query SELECT a.*,z.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 321908 Query SELECT a.*,z.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 321908 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 321908 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 321908 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 321908 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 321908 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 321908 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 321908 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 321908 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 321908 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 321908 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 321908 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321908 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 321908 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 321908 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 321908 Query SELECT cid,word,parentid,cname,word,img,target,linktype,linkurl FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 321908 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321908 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 321908 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 321908 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=2 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=12 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=3 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=15 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=4 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=19 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=20 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=21 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=60 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=22 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=46 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=44 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=47 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=55 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=56 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=57 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=58 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=59 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=74 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=75 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=76 AND flag=1 AND front=1 ORDER BY orders ASC 321908 Query SELECT * FROM xycms_productcate WHERE parentid=77 AND flag=1 AND front=1 ORDER BY orders ASC 321908 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='416' 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT `cname` FROM xycms_productcate where flag=1 and cid=50 321908 Query SELECT tag,url FROM xycms_tag WHERE enabled=1 ORDER BY tagid asc 321908 Query SELECT * FROM xycms_region 321908 Query SELECT * FROM xycms_product WHERE (flag=1 and tag like '%   公园健身器材%' or tag like '%公园健身器材价格%' or tag like '%公园健身器材批发%') and `id` <> 416 ORDER BY timeline DESC limit 10 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_region where flag=1 321908 Query SELECT * FROM xycms_info WHERE flag=1 and tag like '%   公园健身器材%' or tag like '%公园健身器材价格%' or tag like '%公园健身器材批发%' ORDER BY timeline DESC limit 10 321908 Query SELECT orders FROM xycms_product where id='416' and flag=1 321908 Query SELECT id,title,orders FROM xycms_product WHERE orders > 217 AND cid=(SELECT cid FROM xycms_product WHERE id = 416) AND front=1 ORDER BY orders DESC 321908 Query SELECT orders FROM xycms_product where id='416' and flag=1 321908 Query SELECT id,title,orders FROM xycms_product WHERE orders < 217 AND cid=(SELECT cid FROM xycms_product WHERE id = 416) AND front=1 ORDER BY orders DESC 321908 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=50 321908 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=45 321908 Query SELECT cid,cname,parentid,depth FROM xycms_productcate where cid=1 321908 Query SELECT depth, parentid, front FROM xycms_productcate WHERE cid=1 321908 Query SELECT depth FROM xycms_productcate WHERE cid=1 321908 Query SELECT * FROM xycms_productcate WHERE parentid=1 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321908 Query SELECT depth FROM xycms_productcate WHERE cid=45 321908 Query SELECT * FROM xycms_productcate WHERE parentid=45 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321908 Query SELECT depth FROM xycms_productcate WHERE cid=48 321908 Query SELECT depth FROM xycms_productcate WHERE cid=49 321908 Query SELECT depth FROM xycms_productcate WHERE cid=50 321908 Query SELECT depth FROM xycms_productcate WHERE cid=51 321908 Query SELECT depth FROM xycms_productcate WHERE cid=52 321908 Query SELECT depth FROM xycms_productcate WHERE cid=53 321908 Query SELECT depth FROM xycms_productcate WHERE cid=54 321908 Query SELECT * FROM xycms_productcate WHERE parentid=54 AND flag=1 AND front=1 ORDER BY orders,cid DESC 321908 Quit 241022 15:38:52 321909 Connect root@localhost on 321909 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 321909 Query Set global general_log='on' 321909 Query select @@datadir 321909 Query Set global general_log_file='D:/phpStudy/WWW/adbdz/hei.php'