SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000487s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1135 LIMIT 1 [ RunTime:0.000191s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1130 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000174s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000427s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1135 [ RunTime:0.000162s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000550s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1135 [ RunTime:0.000443s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32995,33010,33012,33015,33023,33024,33031,33034,33039,33040,33043,33047,33048,33062,33065,33066,35275,36266,36917,38299,38376,38377,38395,38954,39180,39713,39777,40156,40171,40173,40569,40871,41965,41966,42120,42799,44272,44273,44397,44558,45669,46116,46330,47062,48751,48752,48896,49163,50249,50869,50995,51335,51360,51361,51483,51836,51862,52462,53292,53358,53781,54273,54320,54321,54576,54780,54928,54929,54930,55431,55633,55897,56109,57062,57577,57895,57959,57963,58898,59363,59364,59447,59972,61498,63103,64236,64362,65926,67493,69629) [ RunTime:0.000589s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (32995,33010,33012,33015,33023,33024,33031,33034,33039,33040,33043,33047,33048,33062,33065,33066,35275,36266,36917,38299,38376,38377,38395,38954,39180,39713,39777,40156,40171,40173,40569,40871,41965,41966,42120,42799,44272,44273,44397,44558,45669,46116,46330,47062,48751,48752,48896,49163,50249,50869,50995,51335,51360,51361,51483,51836,51862,52462,53292,53358,53781,54273,54320,54321,54576,54780,54928,54929,54930,55431,55633,55897,56109,57062,57577,57895,57959,57963,58898,59363,59364,59447,59972,61498,63103,64236,64362,65926,67493,69629) AND `brand_id` > 0 [ RunTime:0.000762s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000396s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4553,4591,4606,4560,5012,4438,4445,4555,4554,5292,4604,4483,4948,6193,5228,5585,7139,5912,7657,5030,7028,5003,5000,5848,5245,8005) GROUP BY `name` LIMIT 30 [ RunTime:0.001074s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32995,33010,33012,33015,33023,33024,33031,33034,33039,33040,33043,33047,33048,33062,33065,33066,35275,36266,36917,38299,38376,38377,38395,38954,39180,39713,39777,40156,40171,40173,40569,40871,41965,41966,42120,42799,44272,44273,44397,44558,45669,46116,46330,47062,48751,48752,48896,49163,50249,50869,50995,51335,51360,51361,51483,51836,51862,52462,53292,53358,53781,54273,54320,54321,54576,54780,54928,54929,54930,55431,55633,55897,56109,57062,57577,57895,57959,57963,58898,59363,59364,59447,59972,61498,63103,64236,64362,65926,67493,69629) [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000338s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32995,33010,33012,33015,33023,33024,33031,33034,33039,33040,33043,33047,33048,33062,33065,33066,35275,36266,36917,38299,38376,38377,38395,38954,39180,39713,39777,40156,40171,40173,40569,40871,41965,41966,42120,42799,44272,44273,44397,44558,45669,46116,46330,47062,48751,48752,48896,49163,50249,50869,50995,51335,51360,51361,51483,51836,51862,52462,53292,53358,53781,54273,54320,54321,54576,54780,54928,54929,54930,55431,55633,55897,56109,57062,57577,57895,57959,57963,58898,59363,59364,59447,59972,61498,63103,64236,64362,65926,67493,69629) AND `attr_value` <> '' [ RunTime:0.000751s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000350s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000133s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32995,33010,33012,33015,33023,33024,33031,33034,33039,33040,33043,33047,33048,33062,33065,33066,35275,36266,36917,38299,38376,38377,38395,38954,39180,39713,39777,40156,40171,40173,40569,40871,41965,41966,42120,42799,44272,44273,44397,44558,45669,46116,46330,47062,48751,48752,48896,49163,50249,50869,50995,51335,51360,51361,51483,51836,51862,52462,53292,53358,53781,54273,54320,54321,54576,54780,54928,54929,54930,55431,55633,55897,56109,57062,57577,57895,57959,57963,58898,59363,59364,59447,59972,61498,63103,64236,64362,65926,67493,69629) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000841s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000335s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (33024,48896,54273,33031,33034,49163,39180,44558,33039,33040) [ RunTime:0.001007s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000314s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000104s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000163s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33024 LIMIT 1 [ RunTime:0.000173s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 48896 LIMIT 1 [ RunTime:0.000167s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54273 LIMIT 1 [ RunTime:0.000161s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33031 LIMIT 1 [ RunTime:0.000159s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33034 LIMIT 1 [ RunTime:0.000156s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 49163 LIMIT 1 [ RunTime:0.000143s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 39180 LIMIT 1 [ RunTime:0.000147s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44558 LIMIT 1 [ RunTime:0.000389s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33039 LIMIT 1 [ RunTime:0.000142s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33040 LIMIT 1 [ RunTime:0.000136s ]
