SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.004513s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.001083s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.001918s ]
SELECT `id` FROM `g3ys_category` WHERE `document_type` = 1 AND `subsite_id` = '0' AND `status` = 1 [ RunTime:0.000573s ]
SHOW FULL COLUMNS FROM `g3ys_model` [ RunTime:0.002257s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000500s ]
SHOW FULL COLUMNS FROM `g3ys_attribute` [ RunTime:0.001394s ]
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.000846s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000379s ]
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.000674s ]
SELECT * FROM `g3ys_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000573s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.002113s ]
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 `a`.`id` <> '270' AND ( `category_id` IN (202,8,9,10,11,12,13,15,16,17,343,353) OR FIND_IN_SET('202', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 [ RunTime:0.003534s ]
SELECT `a`.`id`,`a`.`title`,`a`.`price`,`a`.`money_type`,`a`.`is_single`,`a`.`pic`,`a`.`intro`,`a`.`category_id`,`d`.`shape`,`d`.`color`,`d`.`cut`,`d`.`carat`,`d`.`report`,`d`.`clarity`,`d`.`product_code` 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 `a`.`id` <> '270' AND ( `category_id` IN (202,8,9,10,11,12,13,15,16,17,343,353) OR FIND_IN_SET('202', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 ORDER BY `sort` DESC,`update_time` DESC LIMIT 0,10 [ RunTime:0.002610s ]
SELECT `id`,`pid`,`name` FROM `g3ys_category` WHERE ( id=7 ) LIMIT 1 [ RunTime:0.000433s ]
SELECT * FROM `g3ys_category` WHERE `name` = 'diamonds' LIMIT 1 [ RunTime:0.000582s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 7 [ RunTime:0.000459s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 202 [ RunTime:0.000326s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 8 [ RunTime:0.000315s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 9 [ RunTime:0.000405s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 10 [ RunTime:0.000305s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 11 [ RunTime:0.000299s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 12 [ RunTime:0.000297s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 13 [ RunTime:0.000367s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 15 [ RunTime:0.000453s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 16 [ RunTime:0.000317s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 17 [ RunTime:0.000302s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 343 [ RunTime:0.000299s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 353 [ RunTime:0.000403s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 364 [ RunTime:0.000301s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 366 [ RunTime:0.000299s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 369 [ RunTime:0.000327s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 371 [ RunTime:0.000309s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 373 [ RunTime:0.000412s ]
SELECT `id` FROM `g3ys_category` WHERE `pid` = 374 [ RunTime:0.000313s ]
SELECT * FROM `g3ys_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `g3ys_ad_location` [ RunTime:0.001570s ]
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.001570s ]
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.000702s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000370s ]
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.000432s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000489s ]
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.000627s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000456s ]
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.000571s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000421s ]
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.000541s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000476s ]
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.000679s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000363s ]
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.000429s ]
SELECT * FROM `g3ys_document` WHERE ( `name` = '0' OR `id` = '0' ) AND `subsite_id` = 0 LIMIT 1 [ RunTime:0.002495s ]
SHOW FULL COLUMNS FROM `g3ys_document_diamond` [ RunTime:0.004004s ]
SELECT MIN(`carat`) AS think_min FROM `g3ys_document_diamond` WHERE `carat` > '0' [ RunTime:0.001164s ]
SELECT MAX(`carat`) AS think_max FROM `g3ys_document_diamond` WHERE `carat` > '0' [ RunTime:0.000858s ]
SELECT MIN(`price`) AS think_min FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (7,202,364,8,9,10,11,12,13,15,16,17,343,353,366,369,371,373,374) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.006320s ]
SELECT MAX(`price`) AS think_max FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (7,202,364,8,9,10,11,12,13,15,16,17,343,353,366,369,371,373,374) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.006694s ]
SELECT MIN(`lw_ratio`) AS think_min FROM `g3ys_document_diamond` [ RunTime:0.000686s ]
SELECT MAX(`lw_ratio`) AS think_max FROM `g3ys_document_diamond` [ RunTime:0.000551s ]
SELECT MIN(`table_percent`) AS think_min FROM `g3ys_document_diamond` [ RunTime:0.000417s ]
SELECT MAX(`table_percent`) AS think_max FROM `g3ys_document_diamond` [ RunTime:0.000395s ]
SELECT MIN(`depth_percent`) AS think_min FROM `g3ys_document_diamond` [ RunTime:0.000480s ]
SELECT MAX(`depth_percent`) AS think_max FROM `g3ys_document_diamond` [ RunTime:0.000823s ]