SHOW FULL COLUMNS FROM `shop_type` [ RunTime:0.001138s ]
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.000787s ]
SHOW FULL COLUMNS FROM `shop_good` [ RunTime:0.001189s ]
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.000826s ]
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.000772s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 13 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.002030s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 55 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001909s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 37 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001758s ]
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.001306s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 21 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001008s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 20 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001261s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 40 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001041s ]
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.000873s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 45 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001099s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 44 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001282s ]
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.002374s ]
SHOW FULL COLUMNS FROM `shop_images` [ RunTime:0.001028s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (295,154,300,170,299) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.001226s ]
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.000700s ]
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.000710s ]
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.000709s ]
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.000794s ]
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.000752s ]
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.000927s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 63 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001213s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 52 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001092s ]
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.000798s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 76 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001330s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 75 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001172s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 66 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001094s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 74 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001087s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 74 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.001865s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (349,346,343,348,344) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000859s ]
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.000664s ]
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.000827s ]
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.000910s ]
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.000767s ]
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.000726s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 80 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000983s ]
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.000706s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 81 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001103s ]
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.002036s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (350,262,260,259,351) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000878s ]
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.000683s ]
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.000669s ]
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.000695s ]
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.000710s ]
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.000737s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 70 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001113s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 54 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000970s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 64 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000979s ]
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.000644s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 73 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000966s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 72 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000965s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 71 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000991s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 64 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.001705s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (352,257,353,255,258) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000843s ]
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.000660s ]
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.000786s ]
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.000747s ]
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.000706s ]
SHOW FULL COLUMNS FROM `shop_article` [ RunTime:0.001070s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 1 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.001261s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 2 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.000884s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 3 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.000972s ]
SHOW FULL COLUMNS FROM `shop_comment` [ RunTime:0.001184s ]
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.000808s ]
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.000863s ]
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.000815s ]
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.001027s ]
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.000808s ]
SELECT * FROM `shop_type` WHERE ( `id` = 65 ) AND `shop_type`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000818s ]
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.001461s ]
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.001017s ]
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.000924s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 76 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.002109s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 76 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000846s ]
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.001039s ]
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.000831s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 75 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001908s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 75 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.001017s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (329,330,331,332,333,334,335) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.001390s ]
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.000909s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 66 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001884s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 66 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000760s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (336,337,338,339,340,341,342) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000940s ]
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.000826s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 74 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001615s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 74 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000784s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (343,344,345,346,347,348,349) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.001077s ]