SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.002500s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000666s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.001867s ]
SELECT `id` FROM `g3ys_category` WHERE `document_type` = 1 AND `subsite_id` = '0' AND `status` = 1 [ RunTime:0.000634s ]
SHOW FULL COLUMNS FROM `g3ys_model` [ RunTime:0.003055s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `g3ys_attribute` [ RunTime:0.001838s ]
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.000994s ]
SELECT `extend` FROM `g3ys_model` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000421s ]
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.000909s ]
SHOW TABLES LIKE 'g3ys_document_diamond' [ RunTime:0.002351s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.003093s ]
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 (85,86,89,90,91,92,93,94,95,96,97,98,213,214,215,216,217,218,219,220,221,87,99,100,101,102,103,104,105,106,107,108,88,109,110,111,112,113,114,115,116,117,118,119,208,209,210,211,212) OR FIND_IN_SET('85', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 [ RunTime:0.001876s ]
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 (85,86,89,90,91,92,93,94,95,96,97,98,213,214,215,216,217,218,219,220,221,87,99,100,101,102,103,104,105,106,107,108,88,109,110,111,112,113,114,115,116,117,118,119,208,209,210,211,212) OR FIND_IN_SET('85', `category_ids`) ) AND `status` = '1' AND `document_type` = 1 AND `subsite_id` = 0 ORDER BY `sort` DESC,`update_time` DESC LIMIT 20,10 [ RunTime:0.001823s ]
SHOW FULL COLUMNS FROM `g3ys_ad_location` [ RunTime:0.002409s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000570s ]
SHOW FULL COLUMNS FROM `g3ys_ad` [ RunTime:0.001989s ]
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.000663s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000645s ]
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.000606s ]
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` = '3' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000670s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000544s ]
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.000690s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000661s ]
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.000631s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000606s ]
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.000585s ]
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` = '124' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000645s ]
SELECT `id` FROM `g3ys_ad_location` WHERE `name` = 'nav' AND `subsite_id` = '0' LIMIT 1 [ RunTime:0.000459s ]
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.000580s ]
SELECT * FROM `g3ys_attribute` [ RunTime:0.000972s ]
SHOW FULL COLUMNS FROM `g3ys_file` [ RunTime:0.002377s ]
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.002390s ]
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.002460s ]
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.002318s ]
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.002527s ]
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.002389s ]
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.002482s ]
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.002294s ]
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.002283s ]
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.002304s ]
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.002301s ]
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.002301s ]
SELECT * FROM `g3ys_attribute` [ RunTime:0.000999s ]
SELECT MIN(`price`) AS think_min FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (85,86,87,88,208,89,90,91,92,93,94,95,96,97,98,213,214,215,216,217,218,219,220,221,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,209,210,211,212) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.001811s ]
SELECT MAX(`price`) AS think_max FROM `g3ys_document` WHERE `subsite_id` = 0 AND ( `category_id` IN (85,86,87,88,208,89,90,91,92,93,94,95,96,97,98,213,214,215,216,217,218,219,220,221,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,209,210,211,212) AND `price` > '0' AND `model_id` = 4 ) AND `status` = '1' [ RunTime:0.001778s ]
SHOW FULL COLUMNS FROM `g3ys_document_diamond` [ RunTime:0.002364s ]
SELECT MIN(`width`) AS think_min FROM `g3ys_document_diamond` WHERE `width` > '0' [ RunTime:0.000621s ]
SELECT MAX(`width`) AS think_max FROM `g3ys_document_diamond` WHERE `width` > '0' [ RunTime:0.000435s ]