SHOW FULL COLUMNS FROM `yihsing_setting` [ RunTime:0.000467s ]
SELECT `value` FROM `yihsing_setting` WHERE `key` = 'theme' LIMIT 1 [ RunTime:0.000197s ]
SELECT * FROM `yihsing_setting` [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `yihsing_category` [ RunTime:0.000386s ]
SELECT * FROM `yihsing_category` [ RunTime:0.000155s ]
SHOW FULL COLUMNS FROM `yihsing_company` [ RunTime:0.000377s ]
SELECT * FROM `yihsing_company` [ RunTime:0.000134s ]
SHOW FULL COLUMNS FROM `yihsing_menu` [ RunTime:0.000352s ]
SELECT * FROM `yihsing_menu` [ RunTime:0.000145s ]
SHOW FULL COLUMNS FROM `yihsing_banner` [ RunTime:0.000350s ]
SELECT * FROM `yihsing_banner` ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000165s ]
SHOW FULL COLUMNS FROM `yihsing_link` [ RunTime:0.000352s ]
SELECT * FROM `yihsing_link` [ RunTime:0.000160s ]
SHOW FULL COLUMNS FROM `yihsing_notice` [ RunTime:0.000345s ]
SELECT * FROM `yihsing_notice` ORDER BY `time_add` DESC LIMIT 10 [ RunTime:0.000122s ]
SHOW FULL COLUMNS FROM `yihsing_product_spec` [ RunTime:0.000479s ]
SELECT * FROM `yihsing_product_spec` WHERE `yihsing_product_spec`.`time_delete` IS NULL ORDER BY RAND() LIMIT 10 [ RunTime:0.041563s ]
SHOW FULL COLUMNS FROM `yihsing_post` [ RunTime:0.000551s ]
SELECT * FROM `yihsing_post` WHERE ( `id` = 65 ) AND `yihsing_post`.`time_delete` IS NULL LIMIT 1 [ RunTime:0.000294s ]
SHOW FULL COLUMNS FROM `yihsing_user` [ RunTime:0.000399s ]
SELECT * FROM `yihsing_user` WHERE ( `id` = 1 ) AND `yihsing_user`.`time_delete` IS NULL [ RunTime:0.000229s ]
SHOW FULL COLUMNS FROM `yihsing_meta` [ RunTime:0.000367s ]
SELECT * FROM `yihsing_meta` WHERE `post_id` = 65 [ RunTime:0.000193s ]
SHOW FULL COLUMNS FROM `yihsing_tag` [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `yihsing_post_tag` [ RunTime:0.000352s ]
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` = 65 [ RunTime:0.000278s ]
SELECT * FROM `yihsing_category` WHERE `id` = 9 [ RunTime:0.000268s ]
UPDATE `yihsing_post` SET `view` = 921 WHERE ( `id` = 65 ) AND `yihsing_post`.`time_delete` IS NULL [ RunTime:0.002172s ]
SHOW FULL COLUMNS FROM `yihsing_product` [ RunTime:0.000493s ]
SELECT * FROM `yihsing_product` WHERE ( `id` IN (1425,1404,1417,1393,1386,1385,1396,1388,1394,1406,1397,1405,1410,1387,1398,1375,1395,1415,1419,1426,1431,1411,1429,1399,1293,1333,1347,1376,1389,1384,1403,1400,1401,1407,1378,1390,1424,1423,1422,1428,1427) ) AND `yihsing_product`.`time_delete` IS NULL [ RunTime:0.001074s ]
SELECT * FROM `yihsing_product_spec` WHERE ( `parent_id` IN (1293,1333,1347,1375,1376,1378,1384,1385,1386,1387,1388,1389,1390,1393,1394,1395,1396,1397,1398,1399,1400,1401,1403,1404,1405,1406,1407,1410,1411,1415,1417,1419,1422,1423,1424,1425,1426,1427,1428,1429,1431) ) AND `yihsing_product_spec`.`time_delete` IS NULL [ RunTime:0.005133s ]
SHOW FULL COLUMNS FROM `yihsing_innerlink` [ RunTime:0.000811s ]
SELECT * FROM `yihsing_innerlink` [ RunTime:0.000191s ]
SELECT * FROM `yihsing_post` WHERE ( `id` <> 65 AND `category_id` = 9 ) AND `yihsing_post`.`time_delete` IS NULL ORDER BY time_add desc LIMIT 12 [ RunTime:0.001489s ]
SELECT * FROM `yihsing_user` WHERE ( `id` = 1 ) AND `yihsing_user`.`time_delete` IS NULL [ RunTime:0.000348s ]
SELECT * FROM `yihsing_meta` WHERE `post_id` IN (69,68,67,66,64,63,62) [ RunTime:0.000311s ]
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 (69,68,67,66,64,63,62) [ RunTime:0.000430s ]
SELECT * FROM `yihsing_category` WHERE `id` = 9 [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `yihsing_product_brand` [ RunTime:0.000503s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 1 [ RunTime:0.000187s ]
SHOW FULL COLUMNS FROM `yihsing_comment` [ RunTime:0.000464s ]
SELECT * FROM `yihsing_comment` WHERE `post_id` = 65 ORDER BY `time_add` DESC [ RunTime:0.000205s ]
SELECT * FROM `yihsing_product_brand` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000192s ]
SELECT * FROM `yihsing_tag` [ RunTime:0.000252s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 7 [ RunTime:0.000228s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 8 [ RunTime:0.000184s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 9 [ RunTime:0.000212s ]
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.000190s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 12 [ RunTime:0.000217s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 13 [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 14 [ RunTime:0.000195s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 15 [ RunTime:0.000185s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 16 [ RunTime:0.000183s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 17 [ RunTime:0.000192s ]
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.000188s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 20 [ RunTime:0.000192s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 21 [ RunTime:0.000173s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 22 [ RunTime:0.000194s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 23 [ RunTime:0.000203s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 24 [ RunTime:0.000168s ]
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.000187s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 27 [ RunTime:0.000186s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 28 [ RunTime:0.000191s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 29 [ RunTime:0.000198s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 30 [ RunTime:0.000186s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 31 [ RunTime:0.000173s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 32 [ RunTime:0.000212s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 33 [ RunTime:0.000195s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 34 [ RunTime:0.000186s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 35 [ RunTime:0.000191s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 36 [ RunTime:0.000192s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 37 [ RunTime:0.000192s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 38 [ RunTime:0.000206s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 39 [ RunTime:0.000200s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 40 [ RunTime:0.000180s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 41 [ RunTime:0.000179s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 42 [ RunTime:0.000198s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 43 [ RunTime:0.000191s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 44 [ RunTime:0.000174s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 45 [ RunTime:0.000190s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 46 [ RunTime:0.000188s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 47 [ RunTime:0.000181s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 48 [ RunTime:0.000199s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 49 [ RunTime:0.000205s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 50 [ RunTime:0.000175s ]
SELECT COUNT(*) AS think_count FROM `yihsing_post_tag` WHERE `tag_id` = 51 [ RunTime:0.000191s ]