SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.005543s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.001764s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.006217s ]
SELECT `id` FROM `g3ys_category` WHERE `document_type` = 1 AND `subsite_id` = '0' AND `status` = 1 [ RunTime:0.002004s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.004333s ]
SELECT `id` FROM `g3ys_document` WHERE `category_id` = 120 AND `subsite_id` = 0 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000732s ]
SELECT * FROM `g3ys_document` WHERE ( `name` = '117' OR `id` = '117' ) AND `subsite_id` = 0 LIMIT 1 [ RunTime:0.002168s ]
SHOW TABLES LIKE 'g3ys_document_diamond' [ RunTime:0.002435s ]
SHOW FULL COLUMNS FROM `g3ys_document_diamond` [ RunTime:0.002525s ]
SELECT * FROM `g3ys_document_diamond` WHERE `document_id` = 117 LIMIT 1 [ RunTime:0.000679s ]
SHOW FULL COLUMNS FROM `g3ys_total` [ RunTime:0.001980s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '117' LIMIT 1 [ RunTime:0.000742s ]
SHOW FULL COLUMNS FROM `g3ys_model` [ RunTime:0.003044s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000845s ]
SHOW FULL COLUMNS FROM `g3ys_attribute` [ RunTime:0.002173s ]
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.000967s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000519s ]
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.000953s ]
SHOW TABLES LIKE 'g3ys_document_diamond' [ RunTime:0.002498s ]
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` IN (121,125,224,225,226,227,228,229,230,231,232,233,126,234,235,236,237,238,239,240,241,242,243,244,245,246,127,247,248,249,250,251,252,253,254,255,256,257,258,259,128,260,261,262,263,264,265,266,267,268,269,270,122,135,136,137,138,139,141,143,123,198,199,200,201) OR FIND_IN_SET('120', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 AND FIND_IN_SET('diamond', `gemstone`) [ RunTime:0.002384s ]
SELECT `id`,`title`,`price`,`money_type`,`pic`,`intro`,`is_single`,`product_code`,`combined_title` 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` IN (121,125,224,225,226,227,228,229,230,231,232,233,126,234,235,236,237,238,239,240,241,242,243,244,245,246,127,247,248,249,250,251,252,253,254,255,256,257,258,259,128,260,261,262,263,264,265,266,267,268,269,270,122,135,136,137,138,139,141,143,123,198,199,200,201) OR FIND_IN_SET('120', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 AND FIND_IN_SET('diamond', `gemstone`) ORDER BY `sort` DESC,`update_time` DESC LIMIT 0,10 [ RunTime:0.002307s ]
SHOW FULL COLUMNS FROM `g3ys_ad_location` [ RunTime:0.002168s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `g3ys_ad` [ RunTime:0.001970s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '2' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000705s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000643s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '2' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000634s ]
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 `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '3' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000675s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000586s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '3' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000652s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000514s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '7' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000591s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000406s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '7' 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.000486s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '120' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.001249s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000485s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '120' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000591s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000439s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '124' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000595s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000391s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '0' AND `status` = 1 AND `ad_location_id` = '6' AND `category_id` = '124' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000611s ]
SELECT * FROM `g3ys_attribute` [ RunTime:0.001060s ]
SHOW FULL COLUMNS FROM `g3ys_file` [ RunTime:0.002204s ]
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.002321s ]
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.002445s ]
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.002426s ]
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.002813s ]
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.002493s ]
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.002238s ]
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.002561s ]
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.002368s ]
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.002401s ]
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.002333s ]
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.002458s ]
SELECT * FROM `g3ys_attribute` [ RunTime:0.000941s ]
SELECT MIN(`price`) AS think_min FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (120,121,122,123,198,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,135,136,137,138,139,141,143,145,146,147,148,149,271,272,273,199,200,201) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.002233s ]
SELECT MAX(`price`) AS think_max FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (120,121,122,123,198,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,135,136,137,138,139,141,143,145,146,147,148,149,271,272,273,199,200,201) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.001546s ]