SHOW FULL COLUMNS FROM `yihsing_setting` [ RunTime:0.009440s ]
SELECT `value` FROM `yihsing_setting` WHERE `key` = 'theme' LIMIT 1 [ RunTime:0.002825s ]
SELECT * FROM `yihsing_setting` [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `yihsing_category` [ RunTime:0.009989s ]
SELECT * FROM `yihsing_category` [ RunTime:0.001203s ]
SHOW FULL COLUMNS FROM `yihsing_company` [ RunTime:0.001789s ]
SELECT * FROM `yihsing_company` [ RunTime:0.000184s ]
SHOW FULL COLUMNS FROM `yihsing_menu` [ RunTime:0.005953s ]
SELECT * FROM `yihsing_menu` [ RunTime:0.001611s ]
SHOW FULL COLUMNS FROM `yihsing_banner` [ RunTime:0.000583s ]
SELECT * FROM `yihsing_banner` ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.005478s ]
SHOW FULL COLUMNS FROM `yihsing_link` [ RunTime:0.000790s ]
SELECT * FROM `yihsing_link` [ RunTime:0.004390s ]
SHOW FULL COLUMNS FROM `yihsing_notice` [ RunTime:0.009486s ]
SELECT * FROM `yihsing_notice` ORDER BY `time_add` DESC LIMIT 10 [ RunTime:0.000249s ]
SHOW FULL COLUMNS FROM `yihsing_product_spec` [ RunTime:0.006335s ]
SELECT * FROM `yihsing_product_spec` WHERE `yihsing_product_spec`.`time_delete` IS NULL ORDER BY RAND() LIMIT 10 [ RunTime:0.407045s ]
SHOW FULL COLUMNS FROM `yihsing_product` [ RunTime:0.006998s ]
SELECT * FROM `yihsing_product` WHERE ( `id` = 1831 ) AND `yihsing_product`.`time_delete` IS NULL LIMIT 1 [ RunTime:0.007954s ]
SELECT * FROM `yihsing_product_spec` WHERE ( `parent_id` = 1831 ) AND `yihsing_product_spec`.`time_delete` IS NULL [ RunTime:0.028546s ]
SHOW FULL COLUMNS FROM `yihsing_product_brand` [ RunTime:0.007735s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 [ RunTime:0.000380s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000164s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000191s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000733s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.004064s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000160s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000170s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000165s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.005060s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000180s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000671s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.002097s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000237s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000186s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000660s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.005780s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000464s ]
SHOW FULL COLUMNS FROM `yihsing_tag` [ RunTime:0.004995s ]
SELECT * FROM `yihsing_tag` [ RunTime:0.000844s ]
SHOW FULL COLUMNS FROM `yihsing_post_tag` [ RunTime:0.002452s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 7 [ RunTime:0.002234s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 8 [ RunTime:0.000456s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 9 [ RunTime:0.000390s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 10 [ RunTime:0.001231s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 11 [ RunTime:0.005885s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 12 [ RunTime:0.000677s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 13 [ RunTime:0.000346s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 14 [ RunTime:0.002133s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 15 [ RunTime:0.000863s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 16 [ RunTime:0.004490s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 17 [ RunTime:0.001625s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 18 [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 19 [ RunTime:0.000179s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 20 [ RunTime:0.000227s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 21 [ RunTime:0.000192s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 22 [ RunTime:0.002769s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 23 [ RunTime:0.001165s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 24 [ RunTime:0.003072s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 25 [ RunTime:0.000201s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 26 [ RunTime:0.000213s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 27 [ RunTime:0.002635s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 28 [ RunTime:0.000215s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 29 [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 30 [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 31 [ RunTime:0.000215s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 32 [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 33 [ RunTime:0.004054s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 34 [ RunTime:0.000191s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 35 [ RunTime:0.000218s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 36 [ RunTime:0.000208s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 37 [ RunTime:0.003806s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 38 [ RunTime:0.000201s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 39 [ RunTime:0.000192s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 40 [ RunTime:0.000223s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 41 [ RunTime:0.001044s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 42 [ RunTime:0.002821s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 43 [ RunTime:0.001606s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 44 [ RunTime:0.000217s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 45 [ RunTime:0.000194s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 46 [ RunTime:0.000179s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 47 [ RunTime:0.000192s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 48 [ RunTime:0.004925s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 49 [ RunTime:0.000403s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 50 [ RunTime:0.000223s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 51 [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `yihsing_post` [ RunTime:0.005479s ]
SELECT * FROM `yihsing_category` [ RunTime:0.001580s ]
SELECT * FROM `yihsing_post` WHERE ( `type` = 'post' AND `category_id` IN (2,6,7,8,9,10,11,12,13,15,16,14,17) ) AND `yihsing_post`.`time_delete` IS NULL ORDER BY rand() LIMIT 12 [ RunTime:0.018951s ]
SELECT * FROM `yihsing_category` WHERE `id` IN (7,15,12,8,17,16,6) [ RunTime:0.004259s ]
SELECT `yihsing_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`tag_id` AS `pivot__tag_id` FROM `yihsing_tag` INNER JOIN `yihsing_post_tag` `pivot` ON `pivot`.`tag_id`=`yihsing_tag`.`id` WHERE `pivot`.`post_id` IN (131,163,77,307,303,156,141,155,147,128,157,297) [ RunTime:0.007701s ]
SHOW FULL COLUMNS FROM `yihsing_meta` [ RunTime:0.003950s ]
SELECT * FROM `yihsing_meta` WHERE `post_id` IN (131,163,77,307,303,156,141,155,147,128,157,297) [ RunTime:0.001205s ]
SHOW FULL COLUMNS FROM `yihsing_user` [ RunTime:0.014252s ]
SELECT * FROM `yihsing_user` WHERE ( `id` = 1 ) AND `yihsing_user`.`time_delete` IS NULL [ RunTime:0.001048s ]