SHOW FULL COLUMNS FROM `mok_pintuan` [ RunTime:0.000549s ]
SELECT * FROM `mok_pintuan` WHERE `pintuan_state` = 'wpay' OR `pintuan_state` = 'wtuan' [ RunTime:0.000229s ]
SHOW FULL COLUMNS FROM `mok_order` [ RunTime:0.000629s ]
SELECT * FROM `mok_order` WHERE `order_state` = 'wpay' [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `mok_huodong` [ RunTime:0.000429s ]
SELECT * FROM `mok_huodong` WHERE `huodong_state` <> 'over' [ RunTime:0.000210s ]
SELECT * FROM `mok_huodong` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000220s ]
SHOW FULL COLUMNS FROM `mok_huodong_product` [ RunTime:0.000562s ]
UPDATE `mok_huodong_product` SET `huodong_state` = 'work' , `huodong_id` = 1 WHERE `huodong_id` = 1 [ RunTime:0.003668s ]
SHOW FULL COLUMNS FROM `mok_system` [ RunTime:0.000621s ]
SELECT * FROM `mok_system` [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `mok_arctype` [ RunTime:0.000663s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `current_channel` = 9 [ RunTime:0.000446s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 23 [ RunTime:0.000355s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 75 [ RunTime:0.000239s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 77 [ RunTime:0.000270s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 79 [ RunTime:0.000312s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 78 [ RunTime:0.000247s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 73 [ RunTime:0.000224s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 75 [ RunTime:0.000347s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 78 [ RunTime:0.000901s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 77 [ RunTime:0.000267s ]
SELECT `id`,`current_channel`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `parent_id` = 79 [ RunTime:0.000207s ]
SHOW FULL COLUMNS FROM `mok_product` [ RunTime:0.000632s ]
SELECT `product`.`id`,`product`.`title`,`product`.`cover`,`product`.`price`,`product`.`market_price`,`huodongproduct`.`product_id` AS `huodongproduct__product_id`,`huodongproduct`.`product_name` AS `huodongproduct__product_name`,`huodongproduct`.`product_logo` AS `huodongproduct__product_logo`,`huodongproduct`.`product_money` AS `huodongproduct__product_money`,`huodongproduct`.`product_ymoney` AS `huodongproduct__product_ymoney`,`huodongproduct`.`product_rule` AS `huodongproduct__product_rule`,`huodongproduct`.`product_num` AS `huodongproduct__product_num`,`huodongproduct`.`product_sellnum` AS `huodongproduct__product_sellnum`,`huodongproduct`.`pintuan_num` AS `huodongproduct__pintuan_num`,`huodongproduct`.`product_order` AS `huodongproduct__product_order`,`huodongproduct`.`huodong_id` AS `huodongproduct__huodong_id`,`huodongproduct`.`huodong_type` AS `huodongproduct__huodong_type`,`huodongproduct`.`product_zhe` AS `huodongproduct__product_zhe`,`huodongproduct`.`huodong_tag` AS `huodongproduct__huodong_tag`,`huodongproduct`.`huodong_state` AS `huodongproduct__huodong_state`,`huodongproduct`.`huodong_stime` AS `huodongproduct__huodong_stime`,`huodongproduct`.`huodong_etime` AS `huodongproduct__huodong_etime` FROM `mok_product` `product` LEFT JOIN `mok_huodong_product` `huodongproduct` ON `product`.`id`=`huodongproduct`.`product_id` WHERE `cate_id` IN (23,75,77,79,78) LIMIT 9 [ RunTime:0.000896s ]
SELECT `product`.`id`,`product`.`title`,`product`.`cover`,`product`.`price`,`product`.`market_price`,`huodongproduct`.`product_id` AS `huodongproduct__product_id`,`huodongproduct`.`product_name` AS `huodongproduct__product_name`,`huodongproduct`.`product_logo` AS `huodongproduct__product_logo`,`huodongproduct`.`product_money` AS `huodongproduct__product_money`,`huodongproduct`.`product_ymoney` AS `huodongproduct__product_ymoney`,`huodongproduct`.`product_rule` AS `huodongproduct__product_rule`,`huodongproduct`.`product_num` AS `huodongproduct__product_num`,`huodongproduct`.`product_sellnum` AS `huodongproduct__product_sellnum`,`huodongproduct`.`pintuan_num` AS `huodongproduct__pintuan_num`,`huodongproduct`.`product_order` AS `huodongproduct__product_order`,`huodongproduct`.`huodong_id` AS `huodongproduct__huodong_id`,`huodongproduct`.`huodong_type` AS `huodongproduct__huodong_type`,`huodongproduct`.`product_zhe` AS `huodongproduct__product_zhe`,`huodongproduct`.`huodong_tag` AS `huodongproduct__huodong_tag`,`huodongproduct`.`huodong_state` AS `huodongproduct__huodong_state`,`huodongproduct`.`huodong_stime` AS `huodongproduct__huodong_stime`,`huodongproduct`.`huodong_etime` AS `huodongproduct__huodong_etime` FROM `mok_product` `product` LEFT JOIN `mok_huodong_product` `huodongproduct` ON `product`.`id`=`huodongproduct`.`product_id` WHERE `cate_id` = 73 LIMIT 9 [ RunTime:0.000330s ]
SHOW FULL COLUMNS FROM `mok_archives` [ RunTime:0.000890s ]
SELECT * FROM `mok_archives` [ RunTime:0.000365s ]
SHOW FULL COLUMNS FROM `mok_article_content` [ RunTime:0.000410s ]
SELECT * FROM `mok_article_content` WHERE `aid` IN (1,2,3,4) [ RunTime:0.000213s ]
SELECT * FROM `mok_product` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000637s ]
SELECT * FROM `mok_huodong_product` WHERE `product_id` = 4 AND `huodong_state` = 'work' LIMIT 1 [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `mok_product_sku` [ RunTime:0.000548s ]
SELECT * FROM `mok_product_sku` WHERE `product_id` = 4 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `mok_product_spec` [ RunTime:0.000554s ]
SELECT * FROM `mok_product_spec` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000189s ]
SELECT * FROM `mok_product_spec` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000193s ]
SHOW FULL COLUMNS FROM `mok_product_spec_value` [ RunTime:0.000516s ]
SELECT * FROM `mok_product_spec_value` WHERE `product_id` = 4 AND `is_checked` = 1 AND `spec_id` = 2 ORDER BY `id` ASC [ RunTime:0.000541s ]
SELECT * FROM `mok_product_spec_value` WHERE `product_id` = 4 AND `is_checked` = 1 AND `spec_id` = 1 ORDER BY `id` ASC [ RunTime:0.000381s ]
SHOW FULL COLUMNS FROM `mok_quan` [ RunTime:0.000575s ]
SELECT * FROM `mok_quan` WHERE ( FIND_IN_SET('4', `product_id`) AND `quan_state` = 1 ) OR ( `product_id` IS NULL AND `quan_state` = 1 ) [ RunTime:0.000377s ]
SELECT `id`,`title`,`posters`,`cover`,`attribute_value`,`cate_id`,`spec_ids`,`price`,`market_price`,`total_sales`,`comment_num` FROM `mok_product` ORDER BY `create_time` DESC LIMIT 0,2 [ RunTime:0.000305s ]
SELECT `id`,`title`,`posters`,`cover`,`attribute_value`,`cate_id`,`spec_ids`,`price`,`market_price`,`total_sales`,`comment_num` FROM `mok_product` WHERE `is_hot` = 1 ORDER BY `total_sales` DESC LIMIT 0,10 [ RunTime:0.000836s ]
SHOW FULL COLUMNS FROM `mok_comment` [ RunTime:0.007531s ]
SELECT COUNT(`id`) AS think_count FROM `mok_comment` WHERE `arc_id` = 4 AND `status` = 1 AND `re_id` = 0 AND `type` = 1 LIMIT 1 [ RunTime:0.000268s ]
SELECT COUNT(*) AS think_count FROM `mok_comment` WHERE `arc_id` = 4 AND `re_id` = 0 AND `status` = 1 AND `type` = 1 AND `star` BETWEEN 0 AND 5 LIMIT 1 [ RunTime:0.000232s ]
SELECT `id`,`content`,`comment_logo`,`star`,`re_id`,`create_time`,`username` FROM `mok_comment` WHERE `arc_id` = 4 AND `re_id` = 0 AND `status` = 1 AND `type` = 1 AND `star` BETWEEN 0 AND 5 LIMIT 0,10 [ RunTime:0.000220s ]
SELECT * FROM `mok_product` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `mok_product` SET `view` = view+1 , `update_time` = 1787902688 WHERE `id` = 4 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `mok_shipping_fee` [ RunTime:0.000747s ]
SELECT * FROM `mok_shipping_fee` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`parent_id`,`topid`,`typename`,`englist_name`,`litpic` FROM `mok_arctype` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000379s ]
SHOW FULL COLUMNS FROM `mok_buylog` [ RunTime:0.000524s ]
SELECT * FROM `mok_buylog` WHERE `product_id` = 4 LIMIT 0,10 [ RunTime:0.001005s ]