SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.002972s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000913s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.002515s ]
SELECT `id` FROM `g3ys_category` WHERE `document_type` = 1 AND `subsite_id` = '0' AND `status` = 1 [ RunTime:0.000911s ]
SHOW FULL COLUMNS FROM `g3ys_model` [ RunTime:0.002192s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000515s ]
SHOW FULL COLUMNS FROM `g3ys_attribute` [ RunTime:0.001524s ]
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.000750s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000453s ]
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.000745s ]
SHOW TABLES LIKE 'g3ys_document_diamond' [ RunTime:0.001795s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.002249s ]
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` = 169 OR FIND_IN_SET('169', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 [ RunTime:0.000871s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=152 ) LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=124 ) LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=152 ) LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=124 ) LIMIT 1 [ RunTime:0.000306s ]
SELECT * FROM `g3ys_attribute` [ RunTime:0.000962s ]
SHOW FULL COLUMNS FROM `g3ys_file` [ RunTime:0.001771s ]
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.001168s ]
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.001130s ]
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.001035s ]
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.001157s ]
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.001089s ]
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.001018s ]
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.001025s ]
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.001013s ]
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.000992s ]
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.001044s ]
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.000997s ]
SELECT * FROM `g3ys_attribute` [ RunTime:0.000747s ]
SELECT MIN(`price`) AS think_min FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (124,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.001388s ]
SELECT MAX(`price`) AS think_max FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (124,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.001302s ]