SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.003170s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000851s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.002562s ]
SELECT `id` FROM `g3ys_category` WHERE `document_type` = 1 AND `subsite_id` = '0' AND `status` = 1 [ RunTime:0.000848s ]
SHOW FULL COLUMNS FROM `g3ys_model` [ RunTime:0.002934s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000484s ]
SHOW FULL COLUMNS FROM `g3ys_attribute` [ RunTime:0.001674s ]
SELECT `id`,`name`,`title`,`field`,`type`,`value`,`remark`,`is_show`,`extra`,`model_id`,`is_must`,`status`,`update_time`,`create_time`,`fields`,`search`,`relative`,`relative_fields` FROM `g3ys_attribute` WHERE `model_id` = 1 [ RunTime:0.000793s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`name`,`title`,`field`,`type`,`value`,`remark`,`is_show`,`extra`,`model_id`,`is_must`,`status`,`update_time`,`create_time`,`fields`,`search`,`relative`,`relative_fields` FROM `g3ys_attribute` WHERE `model_id` IN (4,1) [ RunTime:0.000907s ]
SHOW TABLES LIKE 'g3ys_document_diamond' [ RunTime:0.002086s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.002649s ]
SELECT COUNT(*) AS think_count FROM `g3ys_document` `a` INNER JOIN `g3ys_total` `t` ON `a`.`id`=`t`.`target_id` INNER JOIN `g3ys_document_diamond` `d` ON `a`.`id`=`d`.`document_id` WHERE ( `category_id` = 224 OR FIND_IN_SET('224', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 AND `product_class` = 'diamonds' [ RunTime:0.001225s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=125 ) LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=121 ) LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=120 ) LIMIT 1 [ RunTime:0.000274s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=125 ) LIMIT 1 [ RunTime:0.000273s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=121 ) LIMIT 1 [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `g3ys_ad_location` [ RunTime:0.002040s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000396s ]
SHOW FULL COLUMNS FROM `g3ys_ad` [ RunTime:0.001720s ]
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.000521s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000403s ]
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.000455s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000444s ]
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.000556s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000479s ]
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.000464s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000676s ]
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.000564s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000461s ]
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.000440s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000388s ]
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.000454s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000447s ]
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.000551s ]
SHOW FULL COLUMNS FROM `g3ys_file` [ RunTime:0.002336s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 298 LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 291 LIMIT 1 [ RunTime:0.000547s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 299 LIMIT 1 [ RunTime:0.000528s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 294 LIMIT 1 [ RunTime:0.000527s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 300 LIMIT 1 [ RunTime:0.000434s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 288 LIMIT 1 [ RunTime:0.000441s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 295 LIMIT 1 [ RunTime:0.000477s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 296 LIMIT 1 [ RunTime:0.000499s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 297 LIMIT 1 [ RunTime:0.000436s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 293 LIMIT 1 [ RunTime:0.000507s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 298 LIMIT 1 [ RunTime:0.000901s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 291 LIMIT 1 [ RunTime:0.000604s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 299 LIMIT 1 [ RunTime:0.000534s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 294 LIMIT 1 [ RunTime:0.000551s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 300 LIMIT 1 [ RunTime:0.000471s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 288 LIMIT 1 [ RunTime:0.000496s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 295 LIMIT 1 [ RunTime:0.000519s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 296 LIMIT 1 [ RunTime:0.000467s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 297 LIMIT 1 [ RunTime:0.000477s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `type` = 1 AND `id` = 293 LIMIT 1 [ RunTime:0.000486s ]
SELECT * FROM `g3ys_attribute` [ RunTime:0.000983s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone plain metal' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002460s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone cultured pearl' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002406s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone natural pearl' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002325s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone prasiolite' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002497s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone opal' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002379s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone black diamond' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002346s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone quartz' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002235s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone zircon' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002274s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone chryso beryl' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002128s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone green beryl' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002133s ]
SELECT * FROM `g3ys_file` WHERE `name` = 'gemstone iolite' AND `object_id` = '1' AND `object_type` = 0 AND `type` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002175s ]
SELECT MIN(`price`) AS think_min FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (121,125,126,127,128,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.001376s ]
SELECT MAX(`price`) AS think_max FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (121,125,126,127,128,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.001898s ]