SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.012859s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1686 LIMIT 1 [ RunTime:0.006456s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 998 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.005959s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.013483s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1686 [ RunTime:0.010735s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.008461s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1686 [ RunTime:0.011426s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) [ RunTime:0.021907s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) AND `brand_id` > 0 [ RunTime:0.026124s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.012968s ]
SELECT * FROM `tp_brand` WHERE `id` IN (5113,4567,4570,4629,5178,4566,4565,4569,4911,4619,5617,5649,5872,4517,4725,6875,7075,7178,7139,4798,5002,4545,7033,6661,6057,5603,4482,4551,4949,7928,4592,4785,8010,8018,6949,4807,8052,4768,8020,6954,8093) GROUP BY `name` LIMIT 30 [ RunTime:0.008856s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) [ RunTime:0.009344s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.016026s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) AND `attr_value` <> '' [ RunTime:0.016121s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.005181s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.005171s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.054395s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.014304s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (35036,35037,35038,35041,35042,35043,35044,35045,35046,35047) [ RunTime:0.009581s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.008189s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.005507s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.008807s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35036 LIMIT 1 [ RunTime:0.023196s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35037 LIMIT 1 [ RunTime:0.010482s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35038 LIMIT 1 [ RunTime:0.007152s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35041 LIMIT 1 [ RunTime:0.007474s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35042 LIMIT 1 [ RunTime:0.008506s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35043 LIMIT 1 [ RunTime:0.006426s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35044 LIMIT 1 [ RunTime:0.004511s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35045 LIMIT 1 [ RunTime:0.008385s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35046 LIMIT 1 [ RunTime:0.005450s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35047 LIMIT 1 [ RunTime:0.017588s ]
