SHOW FULL COLUMNS FROM `yihsing_setting` [ RunTime:0.000807s ]
SELECT `value` FROM `yihsing_setting` WHERE `key` = 'theme' LIMIT 1 [ RunTime:0.000254s ]
SELECT * FROM `yihsing_setting` [ RunTime:0.000368s ]
SHOW FULL COLUMNS FROM `yihsing_category` [ RunTime:0.000583s ]
SELECT * FROM `yihsing_category` [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `yihsing_company` [ RunTime:0.000937s ]
SELECT * FROM `yihsing_company` [ RunTime:0.001019s ]
SHOW FULL COLUMNS FROM `yihsing_menu` [ RunTime:0.001884s ]
SELECT * FROM `yihsing_menu` [ RunTime:0.000625s ]
SHOW FULL COLUMNS FROM `yihsing_banner` [ RunTime:0.001638s ]
SELECT * FROM `yihsing_banner` ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000221s ]
SHOW FULL COLUMNS FROM `yihsing_link` [ RunTime:0.004447s ]
SELECT * FROM `yihsing_link` [ RunTime:0.000220s ]
SHOW FULL COLUMNS FROM `yihsing_product_spec` [ RunTime:0.001579s ]
SELECT * FROM `yihsing_product_spec` WHERE `yihsing_product_spec`.`time_delete` IS NULL ORDER BY RAND() LIMIT 10 [ RunTime:0.149973s ]
SHOW FULL COLUMNS FROM `yihsing_post` [ RunTime:0.002631s ]
SELECT * FROM `yihsing_post` WHERE ( `id` = 192 ) AND `yihsing_post`.`time_delete` IS NULL LIMIT 1 [ RunTime:0.002311s ]
SHOW FULL COLUMNS FROM `yihsing_user` [ RunTime:0.000602s ]
SELECT * FROM `yihsing_user` WHERE ( `id` = 1 ) AND `yihsing_user`.`time_delete` IS NULL [ RunTime:0.001142s ]
SHOW FULL COLUMNS FROM `yihsing_meta` [ RunTime:0.001613s ]
SELECT * FROM `yihsing_meta` WHERE `post_id` = 192 [ RunTime:0.001007s ]
SHOW FULL COLUMNS FROM `yihsing_tag` [ RunTime:0.003022s ]
SHOW FULL COLUMNS FROM `yihsing_post_tag` [ RunTime:0.000397s ]
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` = 192 [ RunTime:0.000290s ]
SELECT * FROM `yihsing_category` WHERE `id` = 18 [ RunTime:0.001979s ]
UPDATE `yihsing_post` SET `view` = 357 WHERE ( `id` = 192 ) AND `yihsing_post`.`time_delete` IS NULL [ RunTime:0.008618s ]
SHOW FULL COLUMNS FROM `yihsing_innerlink` [ RunTime:0.002435s ]
SELECT * FROM `yihsing_innerlink` [ RunTime:0.000177s ]
SELECT * FROM `yihsing_post` WHERE ( `id` <> 192 AND `category_id` = 18 ) AND `yihsing_post`.`time_delete` IS NULL ORDER BY time_add desc LIMIT 12 [ RunTime:0.004512s ]
SELECT * FROM `yihsing_user` WHERE ( `id` IN (3,1) ) AND `yihsing_user`.`time_delete` IS NULL [ RunTime:0.002254s ]
SELECT * FROM `yihsing_meta` WHERE `post_id` IN (320,319,263,276,277,278,237,238,239,240,242,243) [ RunTime:0.000250s ]
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 (320,319,263,276,277,278,237,238,239,240,242,243) [ RunTime:0.000308s ]
SELECT * FROM `yihsing_category` WHERE `id` = 18 [ RunTime:0.002613s ]
SHOW FULL COLUMNS FROM `yihsing_product_brand` [ RunTime:0.000586s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` IN (1,0) [ RunTime:0.000199s ]
SHOW FULL COLUMNS FROM `yihsing_comment` [ RunTime:0.000687s ]
SELECT * FROM `yihsing_comment` WHERE `post_id` = 192 ORDER BY `time_add` DESC [ RunTime:0.000221s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000168s ]
SELECT * FROM `yihsing_tag` [ RunTime:0.000235s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 7 [ RunTime:0.000205s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 8 [ RunTime:0.000188s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 9 [ RunTime:0.000208s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 10 [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 11 [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 12 [ RunTime:0.000224s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 13 [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 14 [ RunTime:0.000235s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 15 [ RunTime:0.000176s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 16 [ RunTime:0.000171s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 17 [ RunTime:0.000169s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 18 [ RunTime:0.000185s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 19 [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 20 [ RunTime:0.000169s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 21 [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 22 [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 23 [ RunTime:0.000179s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 24 [ RunTime:0.000216s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 25 [ RunTime:0.000170s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 26 [ RunTime:0.000168s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 27 [ RunTime:0.000183s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 28 [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 29 [ RunTime:0.000165s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 30 [ RunTime:0.000197s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 31 [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 32 [ RunTime:0.000166s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 33 [ RunTime:0.000199s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 34 [ RunTime:0.000180s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 35 [ RunTime:0.000165s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 36 [ RunTime:0.000198s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 37 [ RunTime:0.000180s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 38 [ RunTime:0.000165s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 39 [ RunTime:0.000201s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 40 [ RunTime:0.000258s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 41 [ RunTime:0.000183s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 42 [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 43 [ RunTime:0.000165s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 44 [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 45 [ RunTime:0.000195s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 46 [ RunTime:0.000169s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 47 [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 48 [ RunTime:0.000185s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 49 [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 50 [ RunTime:0.000178s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 51 [ RunTime:0.000198s ]
SELECT * FROM `yihsing_category` [ RunTime:0.000198s ]
SELECT * FROM `yihsing_post` WHERE ( `type` = 'post' AND `category_id` = 18 ) AND `yihsing_post`.`time_delete` IS NULL ORDER BY rand() LIMIT 12 [ RunTime:0.001330s ]
SELECT * FROM `yihsing_category` WHERE `id` = 18 [ RunTime:0.000199s ]
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 (170,219,212,216,276,220,214,186,245,171,211,229) [ RunTime:0.000314s ]
SELECT * FROM `yihsing_meta` WHERE `post_id` IN (170,219,212,216,276,220,214,186,245,171,211,229) [ RunTime:0.000271s ]
SELECT * FROM `yihsing_user` WHERE ( `id` = 1 ) AND `yihsing_user`.`time_delete` IS NULL [ RunTime:0.000230s ]
SELECT * FROM `yihsing_category` [ RunTime:0.000198s ]
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.001261s ]
SELECT * FROM `yihsing_category` WHERE `id` IN (15,8,7,17) [ RunTime:0.000237s ]
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 (298,57,130,163,61,49,143,157,155,138,141,152) [ RunTime:0.000370s ]
SELECT * FROM `yihsing_meta` WHERE `post_id` IN (298,57,130,163,61,49,143,157,155,138,141,152) [ RunTime:0.000230s ]
SELECT * FROM `yihsing_user` WHERE ( `id` = 1 ) AND `yihsing_user`.`time_delete` IS NULL [ RunTime:0.000249s ]