SHOW FULL COLUMNS FROM `shop_type` [ RunTime:0.001409s ]
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.000745s ]
SHOW FULL COLUMNS FROM `shop_good` [ RunTime:0.001172s ]
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.000855s ]
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.000782s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 13 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001291s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 55 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001102s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 37 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001143s ]
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.000860s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 21 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001106s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 20 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001331s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 40 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001243s ]
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.000809s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 45 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001175s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 44 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001406s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 20 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.003095s ]
SHOW FULL COLUMNS FROM `shop_images` [ RunTime:0.001354s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (275,279,274,277,278) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.001029s ]
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.000902s ]
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.000818s ]
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.001059s ]
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.000737s ]
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.000747s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 63 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001178s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 52 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001302s ]
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.000861s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 76 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001248s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 75 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001173s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 66 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001106s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 74 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001368s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 75 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.002305s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (331,332,333,330,335) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000901s ]
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.000812s ]
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.000892s ]
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.001052s ]
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.000890s ]
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.001100s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 80 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001401s ]
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.001028s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 81 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001287s ]
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.002112s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (263,262,351,260,259) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000847s ]
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.000599s ]
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.000641s ]
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.000680s ]
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.000715s ]
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.000701s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 70 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001281s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 54 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001026s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 64 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001148s ]
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.000874s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 73 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000987s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 72 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000994s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 71 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000984s ]
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.001761s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (356,358,354,360,359) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000771s ]
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.000571s ]
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.000856s ]
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.000714s ]
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.000959s ]
SHOW FULL COLUMNS FROM `shop_article` [ RunTime:0.001105s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 1 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.001170s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 2 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.001011s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 3 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.000701s ]
SHOW FULL COLUMNS FROM `shop_comment` [ RunTime:0.001020s ]
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.000741s ]
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.000825s ]
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.000754s ]
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.000782s ]
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.000853s ]
SELECT * FROM `shop_type` WHERE ( `id` = 65 ) AND `shop_type`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000785s ]
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.001361s ]
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.000738s ]
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.000655s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 76 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001815s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 76 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000766s ]
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.000834s ]
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.000880s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 75 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001546s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 75 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000735s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (329,330,331,332,333,334,335) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000871s ]
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.000696s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 66 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001584s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 66 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000684s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (336,337,338,339,340,341,342) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000930s ]
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.000806s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 74 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001522s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 74 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000690s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (343,344,345,346,347,348,349) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000922s ]