SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.003001s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000803s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.002476s ]
SELECT `id` FROM `g3ys_category` WHERE `document_type` = 1 AND `subsite_id` = '0' AND `status` = 1 [ RunTime:0.000893s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.003217s ]
SELECT `id` FROM `g3ys_document` WHERE `category_id` = 7 AND `subsite_id` = 0 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000703s ]
SELECT * FROM `g3ys_document` WHERE ( `name` = '114' OR `id` = '114' ) AND `subsite_id` = 0 LIMIT 1 [ RunTime:0.001983s ]
SHOW TABLES LIKE 'g3ys_document_diamond' [ RunTime:0.002356s ]
SHOW FULL COLUMNS FROM `g3ys_document_diamond` [ RunTime:0.002363s ]
SELECT * FROM `g3ys_document_diamond` WHERE `document_id` = 114 LIMIT 1 [ RunTime:0.000674s ]
SHOW FULL COLUMNS FROM `g3ys_total` [ RunTime:0.001901s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '114' LIMIT 1 [ RunTime:0.000466s ]
SHOW FULL COLUMNS FROM `g3ys_model` [ RunTime:0.002963s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000504s ]
SHOW FULL COLUMNS FROM `g3ys_attribute` [ RunTime:0.001880s ]
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.000856s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000381s ]
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.000826s ]
SHOW TABLES LIKE 'g3ys_document_diamond' [ RunTime:0.002242s ]
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 (202,8,9,10,11,12,13,15,16,17,343,353,203,204,206) OR FIND_IN_SET('7', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 AND `origin` = 'lab grown' [ RunTime:0.001835s ]
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 (202,8,9,10,11,12,13,15,16,17,343,353,203,204,206) OR FIND_IN_SET('7', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 AND `origin` = 'lab grown' ORDER BY `sort` DESC,`update_time` DESC LIMIT 0,12 [ RunTime:0.001554s ]
SHOW FULL COLUMNS FROM `g3ys_ad_location` [ RunTime:0.002098s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000442s ]
SHOW FULL COLUMNS FROM `g3ys_ad` [ RunTime:0.001906s ]
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.000667s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000511s ]
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.000599s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000597s ]
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.000430s ]
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.000594s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000525s ]
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.000585s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000587s ]
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.000612s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000545s ]
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.000644s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000515s ]
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.000691s ]
SELECT MIN(`carat`) AS think_min FROM `g3ys_document_diamond` [ RunTime:0.000626s ]
SELECT MAX(`carat`) AS think_max FROM `g3ys_document_diamond` [ RunTime:0.000393s ]
SELECT MIN(`price`) AS think_min FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (7,202,203,8,9,10,11,12,13,15,16,17,343,353,204,206) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.001434s ]
SELECT MAX(`price`) AS think_max FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (7,202,203,8,9,10,11,12,13,15,16,17,343,353,204,206) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.001476s ]
SELECT MIN(`lw_ratio`) AS think_min FROM `g3ys_document_diamond` [ RunTime:0.000566s ]
SELECT MAX(`lw_ratio`) AS think_max FROM `g3ys_document_diamond` [ RunTime:0.000401s ]
SELECT MIN(`table_percent`) AS think_min FROM `g3ys_document_diamond` [ RunTime:0.000371s ]
SELECT MAX(`table_percent`) AS think_max FROM `g3ys_document_diamond` [ RunTime:0.000346s ]
SELECT MIN(`depth_percent`) AS think_min FROM `g3ys_document_diamond` [ RunTime:0.000358s ]
SELECT MAX(`depth_percent`) AS think_max FROM `g3ys_document_diamond` [ RunTime:0.000348s ]