SHOW FULL COLUMNS FROM `shop_type` [ RunTime:0.001544s ]
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.000382s ]
SHOW FULL COLUMNS FROM `shop_good` [ RunTime:0.001218s ]
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.000369s ]
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.000388s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 13 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000824s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 55 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000728s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 37 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000769s ]
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.000369s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 21 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000953s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 20 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000839s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 40 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000856s ]
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.000366s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 45 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000746s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 44 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000780s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 40 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.002156s ]
SHOW FULL COLUMNS FROM `shop_images` [ RunTime:0.001751s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (284,285,286,282,136) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000547s ]
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.000496s ]
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.000396s ]
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.000364s ]
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.000401s ]
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.000515s ]
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.000439s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 63 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001053s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 52 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000852s ]
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.000387s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 76 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000778s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 75 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000794s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 66 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000762s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 74 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000760s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 66 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.001789s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (342,340,338,339,341) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000527s ]
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.000388s ]
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.000372s ]
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.000313s ]
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.000339s ]
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.000350s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 80 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001032s ]
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.000336s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 81 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000869s ]
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.002443s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (262,351,261,260,350) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000649s ]
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.000701s ]
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.000486s ]
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.000416s ]
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.000457s ]
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.000367s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 70 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001088s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 54 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000969s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 64 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000866s ]
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.000402s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 73 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000952s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 72 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000847s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 71 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000815s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 70 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.002030s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (355,354,356,359,358) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000629s ]
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.000410s ]
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.000433s ]
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.000448s ]
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.000401s ]
SHOW FULL COLUMNS FROM `shop_article` [ RunTime:0.002523s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 1 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.000428s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 2 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.000417s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 3 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `shop_comment` [ RunTime:0.001709s ]
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.000386s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 76 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000424s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 75 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000420s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 66 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000451s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 74 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000582s ]
SELECT * FROM `shop_type` WHERE ( `id` = 65 ) AND `shop_type`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000368s ]
SELECT * FROM `shop_good` WHERE ( `status` = '1' AND `delete_time` IS NULL AND `good_type_id` = 65 ) AND `shop_good`.`delete_time` IS NULL ORDER BY `create_time` DESC [ RunTime:0.000936s ]
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.000476s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 76 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000386s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 76 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001235s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 76 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000416s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (321,322,323,324,325,326,327,328) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000589s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 75 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000574s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 75 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001220s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 75 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000500s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (329,330,331,332,333,334,335) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000546s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 66 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000511s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 66 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001389s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 66 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000447s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (336,337,338,339,340,341,342) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000652s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 74 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000574s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 74 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001271s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 74 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000348s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (343,344,345,346,347,348,349) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000430s ]