SHOW FULL COLUMNS FROM `shop_type` [ RunTime:0.001049s ]
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.000716s ]
SHOW FULL COLUMNS FROM `shop_good` [ RunTime:0.001144s ]
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.000836s ]
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.000752s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 13 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001108s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 55 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001797s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 37 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001150s ]
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.000677s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 21 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001215s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 20 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000967s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 40 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001113s ]
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.000732s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 45 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001098s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 44 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001029s ]
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.002121s ]
SHOW FULL COLUMNS FROM `shop_images` [ RunTime:0.000968s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (170,172,300,154,294) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.001101s ]
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.000782s ]
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.000820s ]
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.000668s ]
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.000828s ]
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.000716s ]
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.000574s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 63 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000963s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 52 ) 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` = 65 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000626s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 76 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000992s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 75 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000912s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 66 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001012s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 74 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000983s ]
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.001811s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (330,334,332,335,331) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.001128s ]
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.000690s ]
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.000843s ]
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.000920s ]
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.000595s ]
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.000663s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 80 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001031s ]
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.000644s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 81 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001109s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `status` = '1' AND `good_type_id` = 80 ) AND `shop_good`.`delete_time` IS NULL ORDER BY rand() LIMIT 5 [ RunTime:0.001777s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (218,221,220,252,219) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000921s ]
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.000735s ]
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.000729s ]
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.000644s ]
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.000570s ]
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.000611s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 70 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000951s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 54 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000922s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 64 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000902s ]
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.000595s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 73 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001093s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 72 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000974s ]
SELECT COUNT(*) AS think_count FROM `shop_good` WHERE ( `good_type_id` = 71 ) AND `shop_good`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001051s ]
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.001573s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (255,353,352,257,256) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000793s ]
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.000741s ]
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.000692s ]
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.000683s ]
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.000740s ]
SHOW FULL COLUMNS FROM `shop_article` [ RunTime:0.000945s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 1 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.001258s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 2 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.000890s ]
SELECT * FROM `shop_article` WHERE ( `delete_time` IS NULL AND `type_id` = 3 ) AND `shop_article`.`delete_time` IS NULL [ RunTime:0.000723s ]
SHOW FULL COLUMNS FROM `shop_comment` [ RunTime:0.001152s ]
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.000636s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 21 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000720s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 20 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000658s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 40 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000721s ]
SELECT * FROM `shop_type` WHERE ( `id` = 6 ) AND `shop_type`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000799s ]
SELECT * FROM `shop_good` WHERE ( `status` = '1' AND `delete_time` IS NULL AND `good_type_id` = 6 ) AND `shop_good`.`delete_time` IS NULL ORDER BY `create_time` DESC [ RunTime:0.001355s ]
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.000660s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 21 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000773s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 21 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001430s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 21 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000711s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (135,137,138,139,142,143,273) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000965s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 20 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000665s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 20 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001886s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 20 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000791s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (274,275,276,277,278,279,280) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000814s ]
SELECT `type_name`,`id`,`parent_id`,`type_image` FROM `shop_type` WHERE ( `parent_id` = 40 AND `delete_time` IS NULL ) AND `shop_type`.`delete_time` IS NULL ORDER BY `sort` DESC [ RunTime:0.000737s ]
SELECT * FROM `shop_good` WHERE ( `delete_time` IS NULL AND `good_type_id` = 40 ) AND `shop_good`.`delete_time` IS NULL [ RunTime:0.001585s ]
SELECT * FROM `shop_type` WHERE ( `delete_time` IS NULL AND `id` = 40 ) AND `shop_type`.`delete_time` IS NULL [ RunTime:0.000802s ]
SELECT * FROM `shop_images` WHERE ( `good_id` IN (136,281,282,283,284,285,286) ) AND `shop_images`.`delete_time` IS NULL [ RunTime:0.000949s ]