E:\phpStudy\PHPTutorial\MySQL\bin\mysqld.exe, Version: 5.5.53 (MySQL Community Server (GPL)). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument 220512 17:26:50 605 Query select '' 605 Query SHOW VARIABLES LIKE 'profiling' 605 Quit 220512 18:35:52 606 Connect root@localhost on 606 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 606 Quit 607 Connect root@localhost on 607 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 607 Init DB verdigold 607 Query SELECT COUNT(*) FROM mysql.user 220512 18:35:53 607 Query SHOW TABLES FROM `verdigold` 607 Query SHOW TABLE STATUS FROM `verdigold` 607 Query SELECT CURRENT_USER() 607 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT' 607 Query SELECT CURRENT_USER() 607 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER' 607 Query SHOW MASTER STATUS 607 Query SHOW SLAVE STATUS 607 Init DB verdigold 607 Query SHOW VARIABLES LIKE 'collation_database' 607 Query SELECT COUNT(*) FROM `verdigold`.`xycms_map` 607 Query SELECT COUNT(*) FROM `verdigold`.`xycms_mapcate` 607 Query SHOW VARIABLES LIKE 'storage_engine' 607 Query SHOW GRANTS 607 Quit 608 Connect root@localhost on 608 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 608 Query SHOW DATABASES 608 Query SHOW TABLE STATUS FROM `verdigold` 608 Query SHOW TABLES FROM `verdigold` 608 Quit 220512 18:35:56 609 Connect root@localhost on 609 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 609 Init DB verdigold 609 Query SHOW TABLES FROM `verdigold` 609 Query SHOW TABLE STATUS FROM `verdigold` 609 Query SELECT CURRENT_USER() 609 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='EVENT' 609 Query SELECT CURRENT_USER() 609 Query SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER' 609 Quit 610 Connect root@localhost on 610 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 610 Quit 220512 18:35:57 611 Connect root@localhost on 611 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci' 611 Query SET SQL_MODE="" 611 Query SELECT @@session.time_zone 611 Query SET time_zone = "+00:00" 611 Query SHOW PROCEDURE STATUS 611 Query SHOW FUNCTION STATUS 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_address%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_address' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_address` 611 Query SELECT * FROM `verdigold`.`xycms_address` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_address' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_admin%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_admin' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_admin` 611 Query SELECT * FROM `verdigold`.`xycms_admin` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_admin' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_adsfigure%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_adsfigure' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_adsfigure` 611 Query SELECT * FROM `verdigold`.`xycms_adsfigure` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_adsfigure' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_adszone%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_adszone' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_adszone` 611 Query SELECT * FROM `verdigold`.`xycms_adszone` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_adszone' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_album%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_album' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_album` 611 Query SELECT * FROM `verdigold`.`xycms_album` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_album' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_albumcate' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_albumcate` 611 Query SELECT * FROM `verdigold`.`xycms_albumcate` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_albumcate' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_authgroup%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_authgroup' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_authgroup` 611 Query SELECT * FROM `verdigold`.`xycms_authgroup` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_authgroup' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_brand%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_brand' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_brand` 611 Query SELECT * FROM `verdigold`.`xycms_brand` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_brand' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_case%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_case' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_case` 611 Query SELECT * FROM `verdigold`.`xycms_case` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_case' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_casecate' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_casecate` 611 Query SELECT * FROM `verdigold`.`xycms_casecate` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_casecate' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_comments%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_comments' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_comments` 611 Query SELECT * FROM `verdigold`.`xycms_comments` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_comments' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_config%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_config' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_config` 611 Query SELECT * FROM `verdigold`.`xycms_config` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_config' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_delimitlabel%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_delimitlabel' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_delimitlabel` 611 Query SELECT * FROM `verdigold`.`xycms_delimitlabel` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_delimitlabel' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_download%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_download' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_download` 611 Query SELECT * FROM `verdigold`.`xycms_download` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_download' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_downloadcate' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_downloadcate` 611 Query SELECT * FROM `verdigold`.`xycms_downloadcate` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_downloadcate' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_extend%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_extend' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_extend` 611 Query SELECT * FROM `verdigold`.`xycms_extend` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_extend' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_extendlist' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_extendlist` 611 Query SELECT * FROM `verdigold`.`xycms_extendlist` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_extendlist' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_files%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_files' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_files` 611 Query SELECT * FROM `verdigold`.`xycms_files` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_files' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_group%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_group' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_group` 611 Query SELECT * FROM `verdigold`.`xycms_group` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_group' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_guestbook%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_guestbook' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_guestbook` 611 Query SELECT * FROM `verdigold`.`xycms_guestbook` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_guestbook' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_info%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_info' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_info` 611 Query SELECT * FROM `verdigold`.`xycms_info` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_info' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_infocate' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_infocate` 611 Query SELECT * FROM `verdigold`.`xycms_infocate` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_infocate' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_job%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_job' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_job` 611 Query SELECT * FROM `verdigold`.`xycms_job` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_job' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_jobcate' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_jobcate` 611 Query SELECT * FROM `verdigold`.`xycms_jobcate` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_jobcate' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_keywords%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_keywords' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_keywords` 611 Query SELECT * FROM `verdigold`.`xycms_keywords` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_keywords' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_link%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_link' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_link` 611 Query SELECT * FROM `verdigold`.`xycms_link` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_link' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_log%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_log' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_log` 611 Query SELECT * FROM `verdigold`.`xycms_log` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_log' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_map%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_map' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_map` 611 Query SELECT * FROM `verdigold`.`xycms_map` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_map' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_mapcate' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_mapcate` 611 Query SELECT * FROM `verdigold`.`xycms_mapcate` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_mapcate' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_matchregion%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_matchregion' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_matchregion` 611 Query SELECT * FROM `verdigold`.`xycms_matchregion` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_matchregion' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_onlinechat%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_onlinechat' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_onlinechat` 611 Query SELECT * FROM `verdigold`.`xycms_onlinechat` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_onlinechat' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_orders%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_orders' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_orders` 611 Query SELECT * FROM `verdigold`.`xycms_orders` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_orders' 220512 18:35:58 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_p%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_p' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_p` 611 Query SELECT * FROM `verdigold`.`xycms_p` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_p' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_page' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_page` 611 Query SELECT * FROM `verdigold`.`xycms_page` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_page' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_pagecate' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_pagecate` 611 Query SELECT * FROM `verdigold`.`xycms_pagecate` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_pagecate' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_product' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_product` 611 Query SELECT * FROM `verdigold`.`xycms_product` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_product' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_productcate' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_productcate` 611 Query SELECT * FROM `verdigold`.`xycms_productcate` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_productcate' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_region%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_region' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_region` 611 Query SELECT * FROM `verdigold`.`xycms_region` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_region' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_resume%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_resume' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_resume` 611 Query SELECT * FROM `verdigold`.`xycms_resume` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_resume' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_searchtype%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_searchtype' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_searchtype` 611 Query SELECT * FROM `verdigold`.`xycms_searchtype` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_searchtype' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_shopping%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_shopping' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_shopping` 611 Query SELECT * FROM `verdigold`.`xycms_shopping` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_shopping' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_skin%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_skin' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_skin` 611 Query SELECT * FROM `verdigold`.`xycms_skin` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_skin' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_sp%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_sp' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_sp` 611 Query SELECT * FROM `verdigold`.`xycms_sp` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_sp' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_tag%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_tag' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_tag` 611 Query SELECT * FROM `verdigold`.`xycms_tag` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_tag' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_translate%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_translate' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_translate` 611 Query SELECT * FROM `verdigold`.`xycms_translate` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_translate' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms\_user%' 611 Query SHOW TABLE STATUS FROM `verdigold` LIKE 'xycms_user' 611 Query SET SQL_QUOTE_SHOW_CREATE = 1 611 Query SHOW CREATE TABLE `verdigold`.`xycms_user` 611 Query SELECT * FROM `verdigold`.`xycms_user` 611 Query SHOW TRIGGERS FROM `verdigold` LIKE 'xycms_user' 611 Query SELECT EVENT_NAME FROM information_schema.EVENTS WHERE EVENT_SCHEMA= 'verdigold' 611 Query SET time_zone = "SYSTEM" 611 Quit 220512 18:39:42 612 Connect root@localhost on 612 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 612 Query SET sql_mode='' 612 Init DB verdigold 612 Query SELECT * FROM xycms_config LIMIT 1 612 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 612 Query SELECT `tag` FROM xycms_tag WHERE char_length(tag) < 10 and enabled=1 order by rand() limit 12 612 Query Select * From xycms_sp 612 Query SELECT * FROM xycms_searchtype 612 Query SELECT * FROM xycms_region ORDER BY orders ASC 612 Query SELECT `id`,`title` FROM xycms_product where flag=1 order by orders DESC 612 Query SELECT * FROM xycms_onlinechat WHERE flag=1 612 Query SELECT cid FROM xycms_pagecate WHERE flag=1 ORDER BY orders ASC 612 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 612 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 612 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 612 Query SELECT `zoneid`,`slide`,`width`,`height` FROM xycms_adszone WHERE flag=1 ORDER BY orders ASC 612 Query SELECT a.*,z.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 612 Query SELECT a.*,z.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 612 Query SELECT a.*,z.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 612 Query SELECT a.*,z.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 612 Query SELECT a.*,z.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 612 Query SELECT a.*,z.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 612 Query SELECT a.*,z.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 612 Query SELECT a.*,z.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 612 Query SELECT labelid,labelname,labelcontent FROM xycms_delimitlabel WHERE flag=1 AND skinid=1 ORDER BY labelid ASC 612 Query select id,groupid,username,loves,flag from xycms_user where username='' and password='' 612 Query select id,groupid,username,loves,flag from xycms_user where username='' and password='' 612 Query SELECT c.* FROM xycms_productcate AS c WHERE c.flag=1 AND c.parentid=0 ORDER BY c.orders ASC 612 Query SELECT v.* FROM xycms_onlinechat AS v WHERE v.flag=1 ORDER BY v.orders ASC 612 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=1 ORDER BY v.orders ASC 612 Query SELECT v.* FROM xycms_link AS v WHERE v.flag=1 AND linktype=2 ORDER BY v.orders ASC 612 Query SELECT v.* FROM xycms_brand AS v WHERE v.flag=1 ORDER BY v.orders ASC 612 Query SELECT v.* FROM xycms_brand AS v WHERE v.flag=1 ORDER BY v.orders ASC 612 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 612 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 612 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 612 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 612 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_infocate WHERE parentid=1 612 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=1 612 Query SELECT * FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_infocate WHERE parentid=3 612 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=3 612 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_infocate WHERE parentid=4 612 Query SELECT COUNT(id) FROM xycms_info where flag=1 AND cid=4 612 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_infocate WHERE parentid=0 AND depth=0 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_infocate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_infocate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_infocate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 612 Query SELECT v.*,c.cname FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='1' LIMIT 10 612 Query SELECT v.*,c.cname FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='3' LIMIT 10 612 Query SELECT v.*,c.cname FROM xycms_info AS v LEFT JOIN xycms_infocate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='4' LIMIT 10 612 Query SELECT * FROM xycms_casecate WHERE parentid=0 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_casecate WHERE parentid=1 612 Query SELECT cid FROM xycms_casecate WHERE parentid=2 612 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND (cid=1 OR cid=2) 612 Query SELECT * FROM xycms_casecate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_casecate WHERE parentid=2 612 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=2 612 Query SELECT * FROM xycms_casecate WHERE parentid=2 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_casecate WHERE parentid=3 612 Query SELECT cid FROM xycms_casecate WHERE parentid=4 612 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND (cid=3 OR cid=4) 612 Query SELECT * FROM xycms_casecate WHERE parentid=3 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_casecate WHERE parentid=4 612 Query SELECT COUNT(id) FROM xycms_case where flag=1 AND cid=4 612 Query SELECT * FROM xycms_casecate WHERE parentid=4 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_albumcate WHERE parentid=0 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_albumcate WHERE parentid=1 612 Query SELECT COUNT(id) FROM xycms_album where flag=1 AND cid=1 612 Query SELECT * FROM xycms_albumcate WHERE parentid=1 AND flag=1 ORDER BY orders ASC 612 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 612 Query SELECT v.*,c.cname FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='10' 612 Query SELECT c.* FROM xycms_downloadcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 612 Query SELECT v.*,c.cname FROM xycms_download AS v LEFT JOIN xycms_downloadcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='10' LIMIT 10 612 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 612 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='11' 612 Query SELECT c.* FROM xycms_jobcate AS c WHERE c.flag=1 ORDER BY c.orders ASC 612 Query SELECT v.*,c.cname FROM xycms_job AS v LEFT JOIN xycms_jobcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='11' LIMIT 10 612 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 612 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND depth=0 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_productcate WHERE parentid=10 AND flag=1 ORDER BY orders ASC 612 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='6' LIMIT 10 612 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='7' LIMIT 10 612 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='8' LIMIT 10 612 Query SELECT v.*,c.cname FROM xycms_product AS v LEFT JOIN xycms_productcate AS c ON v.cid=c.cid WHERE v.flag=1 AND v.cid='9' LIMIT 10 612 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='10' LIMIT 10 612 Query SELECT * FROM xycms_productcate WHERE parentid=0 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_productcate WHERE parentid=6 612 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=6 612 Query SELECT * FROM xycms_productcate WHERE parentid=6 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_productcate WHERE parentid=7 612 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=7 612 Query SELECT * FROM xycms_productcate WHERE parentid=7 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_productcate WHERE parentid=8 612 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=8 612 Query SELECT * FROM xycms_productcate WHERE parentid=8 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_productcate WHERE parentid=9 612 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=9 612 Query SELECT * FROM xycms_productcate WHERE parentid=9 AND flag=1 ORDER BY orders ASC 612 Query SELECT cid FROM xycms_productcate WHERE parentid=10 612 Query SELECT COUNT(id) FROM xycms_product where flag=1 AND cid=10 612 Query SELECT * FROM xycms_productcate WHERE parentid=10 AND flag=1 ORDER BY orders ASC 612 Query SELECT * FROM xycms_albumcate WHERE parentid=0 AND flag=1 ORDER BY orders ASC 612 Query SELECT COUNT(id) FROM .xycms_guestbook WHERE `isread`='0' 612 Query SELECT * FROM xycms_region ORDER BY orders ASC 612 Query SELECT cid FROM xycms_infocate WHERE parentid=1 612 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 ASC LIMIT 1 612 Query SELECT cid FROM xycms_infocate WHERE parentid=1 612 Query Select v.*,c.cname,c.word From xycms_info As v Left Join xycms_infocate As c On v.cid=c.cid Where v.flag = '1' AND v.cid='1' ORDER BY v.timeline ASC LIMIT 5 612 Query SELECT cid FROM xycms_infocate WHERE parentid=3 612 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 ASC LIMIT 1 612 Query SELECT cid FROM xycms_infocate WHERE parentid=3 612 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 ASC LIMIT 5 612 Query SELECT cid FROM xycms_infocate WHERE parentid=4 612 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 ASC LIMIT 1 612 Query SELECT cid FROM xycms_infocate WHERE parentid=4 612 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 ASC LIMIT 5 612 Quit 613 Connect root@localhost on 613 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary 613 Query SET sql_mode='' 613 Init DB verdigold 613 Query SELECT * FROM xycms_config LIMIT 1 613 Query SELECT skinid,skindir,skinext FROM xycms_skin WHERE flag=1 ORDER BY orders ASC LIMIT 1 613 Query SELECT `id` FROM xycms_info WHERE `flag` = 0 AND `cid` IN (3) ORDER BY `timeline` LIMIT 2 613 Quit