SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.003083s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000830s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.003141s ]
SELECT * FROM `g3ys_document` WHERE ( `name` = '94' OR `id` = '94' ) AND `subsite_id` = 0 LIMIT 1 [ RunTime:0.001601s ]
SHOW TABLES LIKE 'g3ys_document_diamond' [ RunTime:0.002294s ]
SHOW FULL COLUMNS FROM `g3ys_document_diamond` [ RunTime:0.002427s ]
SELECT * FROM `g3ys_document_diamond` WHERE `document_id` = 94 LIMIT 1 [ RunTime:0.000472s ]
SHOW FULL COLUMNS FROM `g3ys_total` [ RunTime:0.001860s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '94' LIMIT 1 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.002234s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=54 ) LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.000485s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '94' LIMIT 1 [ RunTime:0.000421s ]
UPDATE `g3ys_total` SET `view_total` = `view_total` + 1 WHERE `target_id` = '94' [ RunTime:0.005993s ]
SELECT `id`,`title`,`category_id`,`subsite_id`,`sort`,`status`,`pic`,`price`,`money_type`,`pid` FROM `g3ys_document` WHERE `category_id` = 28 AND `subsite_id` = 0 AND `pid` = '0' AND `status` = '1' AND ( ( sort > 0) or ( sort = 0 and id < 94) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`title`,`category_id`,`subsite_id`,`sort`,`status`,`pic`,`price`,`money_type`,`pid` FROM `g3ys_document` WHERE `category_id` = 28 AND `subsite_id` = 0 AND `pid` = '94' AND `status` = '1' ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`title`,`category_id`,`subsite_id`,`sort`,`status`,`pic`,`price`,`money_type`,`pid` FROM `g3ys_document` WHERE `category_id` = 28 AND `subsite_id` = 0 AND `pid` = '0' AND `status` = '1' AND ( ( sort>0 and sort <= 0 and id!=94) or ( sort = 0 and id > 94) ) ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.000808s ]
SHOW FULL COLUMNS FROM `g3ys_ad_location` [ RunTime:0.002170s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `g3ys_ad` [ RunTime:0.001844s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `ad_location_id` = '6' AND `category_id` = '2' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000558s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000521s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `ad_location_id` = '6' AND `category_id` = '2' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000554s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000608s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `ad_location_id` = '6' AND `category_id` = '3' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000564s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000475s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `ad_location_id` = '6' AND `category_id` = '3' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000562s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000598s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `ad_location_id` = '6' AND `category_id` = '7' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000541s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000619s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `ad_location_id` = '6' AND `category_id` = '120' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000532s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000599s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `ad_location_id` = '6' AND `category_id` = '124' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000628s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000549s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `ad_location_id` = '6' AND `category_id` = '124' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000615s ]
SHOW FULL COLUMNS FROM `g3ys_file` [ RunTime:0.002568s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 395 LIMIT 1 [ RunTime:0.000669s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 395 LIMIT 1 [ RunTime:0.000577s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 396 LIMIT 1 [ RunTime:0.000559s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 396 LIMIT 1 [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `g3ys_taxrate` [ RunTime:0.001697s ]
SELECT * FROM `g3ys_taxrate` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`pic`,`price`,`money_type`,`title` FROM `g3ys_document` `a` INNER JOIN `g3ys_total` `b` ON `a`.`id`=`b`.`target_id` INNER JOIN `g3ys_document_diamond` `c` ON `a`.`id`=`c`.`document_id` WHERE `subsite_id` = 0 AND `category_id` = 28 AND `status` = '1' AND `model_id` = 4 AND `document_type` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 0,12 [ RunTime:0.001155s ]