SHOW FULL COLUMNS FROM `shop_type` [ RunTime:0.001205s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 0 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000714s ]
SHOW FULL COLUMNS FROM `shop_good` [ RunTime:0.001023s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 1 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000775s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 8 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000666s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 13 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000935s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 55 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001072s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 37 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001180s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 6 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000746s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 21 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001214s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 20 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001081s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 40 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001245s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 43 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000701s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 45 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001158s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 44 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001318s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 44 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.002361s ]
SHOW FULL COLUMNS FROM `shop_images` [ RunTime:0.000968s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (170,300,295,299,172) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000949s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 1 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000869s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 8 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000642s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 6 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000821s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 43 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000849s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 18 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000773s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 50 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000723s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 63 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001060s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 52 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001063s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 65 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000964s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 76 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001091s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 75 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001106s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 66 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001165s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 74 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001327s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 63 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.001839s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (310,307,309,311,308) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.001055s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 18 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.001058s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 50 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000868s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 65 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000860s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 77 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000763s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 78 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000804s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 80 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001274s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 79 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000606s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 81 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001180s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 81 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.001976s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (261,351,259,260,350) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000961s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 77 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.001067s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 78 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000752s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 79 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000797s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 46 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000688s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 53 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000751s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 70 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001252s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 54 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001127s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 64 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001238s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 68 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000752s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 73 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001130s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 72 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001322s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 71 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001056s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 71 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.001693s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (382,383,377,378,379) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000874s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 46 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000655s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 53 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000891s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 68 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000744s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 0 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000937s ]
SHOW FULL COLUMNS FROM `shop_article` [ RunTime:0.001300s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 1 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.001222s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 2 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.001055s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 3 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.000934s ]
SHOW FULL COLUMNS FROM `shop_comment` [ RunTime:0.001533s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 73 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000730s ]
SELECT * FROM `shop_type` WHERE ( `id` = 73 ) AND `shop_type`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000821s ]
SELECT * FROM `shop_good` WHERE ( `status` = '1' AND `delete_time` IS NULL AND `good_type_id` = 73 ) AND `shop_good`.`delete_time` IS NULL ORDER BY `create_time` DESC [ RunTime:0.001844s ]
SELECT * FROM `shop_images` WHERE ( `good_id` = 369 AND `default_show` = '1' ) AND `shop_images`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000810s ]
SELECT * FROM `shop_images` WHERE ( `good_id` = 368 AND `default_show` = '1' ) AND `shop_images`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000762s ]
SELECT * FROM `shop_images` WHERE ( `good_id` = 367 AND `default_show` = '1' ) AND `shop_images`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000952s ]
SELECT * FROM `shop_images` WHERE ( `good_id` = 365 AND `default_show` = '1' ) AND `shop_images`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001006s ]
SELECT * FROM `shop_images` WHERE ( `good_id` = 364 AND `default_show` = '1' ) AND `shop_images`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000880s ]
SELECT * FROM `shop_images` WHERE ( `good_id` = 363 AND `default_show` = '1' ) AND `shop_images`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000851s ]
SELECT * FROM `shop_images` WHERE ( `good_id` = 362 AND `default_show` = '1' ) AND `shop_images`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000982s ]