SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000559s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1094 LIMIT 1 [ RunTime:0.000237s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000395s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1094 [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000706s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (1094,1095,1096,1715,1734,1760,1761,1763,1764,1766,1770,1772,1773,1774,1776,1777,1779,1781,1808,1864,1866,1867,1883,1884,1887,1920,1958,1961,2019,2021,2023,2057,2063,2080,2166,2167) [ RunTime:0.001646s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605,37373,37835,37836,37837,37838,37839,37840,37841,37842,37843,37844,37845,37846,37847,37848,37849,37850,37851,37852,37853,37854,37855,37856,37857,37858,37859,37860,37861,37862,37863,37864,37865,37866,37867,37868,37869,37870,37871,37872,37873,37874,37875,37876,37877,37878,37879,37880,37881,37882,37883,37884,37885,37886,37887,37888,37889,37890,37891,37892,37893,37894,37895,37896,37897,37898,37899,37900,37901,37902,37903,37904,37905,37906,37907,37908,37909,37910,37911,37912,37913,37914,37915,37916,37917,37918,37919,37920,37921,37922,37923,37924,37925,37926,37927,37928,37929,37930,37931,37932,37933,37934,37935,37936,37937,37938,37939,37940,37941,37942,37943,37944,37945,37946,37947,37948,37949,37950,37951,37952,37953,37954,37955,37956,37957,37958,37959,37960,37961,37962,37963,37964,37965,37966,37967,37968,37969,37970,37971,37972,37973,37974,37975,37976,37977,37978,37979,37980,37981,37982,37983,37984,37985,37986,37987,37988,37989,37990,37991,37992,37993,37994,37995,37996,37997,37998,37999,38000,38001,38002,38003,38004,38005,38006,38007,38008,38009,38010,38011,38012,38013,38014,38015,38016,38017,38018,38019,38020,38021,38022,38023,38024,38025,38026,38027,38028,38029,38030,38031,38032,38033,38034,41998,41999,42000,42001,42002,42003,42004,42005,42006,42007,42008,43433,44434,44435,44436,44437,44438,44439,44440,44441,44442,44443,44444,44445,44446,44447,44448,44449,44450,44451,44452,44453,44454,44455,44456,44457,44458,44459,44460,44461,44462,44463,44464,44465,44466,44467,44468,44469,44470,44471,44472,44473,44474,44475,44476,44477,44478,44479,44480,44481,44482,44483,44484,44485,44486,44487,44488,44489,44490,44491,44528,45248,48949,53548,56124,60121,38424,38426,38427,38431,38434,38437,44074,44075,45508,50933,56034,59754,38428,38429,38433,38435,38436,44070,44071,44073,44076,44079,46595,38550,38551,47711,47712,67869,38552,38553,67633,38554,42383,54534,61067,38555,38556,38557,38558,38559,38794,38795,39728,40315,40316,44803,54625,54626,54627,40415,50934,50935,55772,55773,55774,41338,41339,41340,41341,42278,56033,42215,43325,45179,45180,45181,45182,45183,45184,45185,45186,45187,42276,42277,45507,43521,43522,43565,43566,44072,44100,44127,56002,56003,56008,60299,60300,60301,60302,60303,60304,60305,60306,60308,44804,47592,47593,47594,63169) [ RunTime:0.003179s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605,37373,37835,37836,37837,37838,37839,37840,37841,37842,37843,37844,37845,37846,37847,37848,37849,37850,37851,37852,37853,37854,37855,37856,37857,37858,37859,37860,37861,37862,37863,37864,37865,37866,37867,37868,37869,37870,37871,37872,37873,37874,37875,37876,37877,37878,37879,37880,37881,37882,37883,37884,37885,37886,37887,37888,37889,37890,37891,37892,37893,37894,37895,37896,37897,37898,37899,37900,37901,37902,37903,37904,37905,37906,37907,37908,37909,37910,37911,37912,37913,37914,37915,37916,37917,37918,37919,37920,37921,37922,37923,37924,37925,37926,37927,37928,37929,37930,37931,37932,37933,37934,37935,37936,37937,37938,37939,37940,37941,37942,37943,37944,37945,37946,37947,37948,37949,37950,37951,37952,37953,37954,37955,37956,37957,37958,37959,37960,37961,37962,37963,37964,37965,37966,37967,37968,37969,37970,37971,37972,37973,37974,37975,37976,37977,37978,37979,37980,37981,37982,37983,37984,37985,37986,37987,37988,37989,37990,37991,37992,37993,37994,37995,37996,37997,37998,37999,38000,38001,38002,38003,38004,38005,38006,38007,38008,38009,38010,38011,38012,38013,38014,38015,38016,38017,38018,38019,38020,38021,38022,38023,38024,38025,38026,38027,38028,38029,38030,38031,38032,38033,38034,41998,41999,42000,42001,42002,42003,42004,42005,42006,42007,42008,43433,44434,44435,44436,44437,44438,44439,44440,44441,44442,44443,44444,44445,44446,44447,44448,44449,44450,44451,44452,44453,44454,44455,44456,44457,44458,44459,44460,44461,44462,44463,44464,44465,44466,44467,44468,44469,44470,44471,44472,44473,44474,44475,44476,44477,44478,44479,44480,44481,44482,44483,44484,44485,44486,44487,44488,44489,44490,44491,44528,45248,48949,53548,56124,60121,38424,38426,38427,38431,38434,38437,44074,44075,45508,50933,56034,59754,38428,38429,38433,38435,38436,44070,44071,44073,44076,44079,46595,38550,38551,47711,47712,67869,38552,38553,67633,38554,42383,54534,61067,38555,38556,38557,38558,38559,38794,38795,39728,40315,40316,44803,54625,54626,54627,40415,50934,50935,55772,55773,55774,41338,41339,41340,41341,42278,56033,42215,43325,45179,45180,45181,45182,45183,45184,45185,45186,45187,42276,42277,45507,43521,43522,43565,43566,44072,44100,44127,56002,56003,56008,60299,60300,60301,60302,60303,60304,60305,60306,60308,44804,47592,47593,47594,63169) AND `brand_id` > 0 [ RunTime:0.003070s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000469s ]
SELECT * FROM `tp_brand` WHERE `id` IN (6394,6266,6031,6018,6107,6284,6081,6401,6395,6099,6660,6755,6807,6629,5883,7139,4450,6661,7647,6236,5679,7116,5716) GROUP BY `name` LIMIT 30 [ RunTime:0.000708s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605,37373,37835,37836,37837,37838,37839,37840,37841,37842,37843,37844,37845,37846,37847,37848,37849,37850,37851,37852,37853,37854,37855,37856,37857,37858,37859,37860,37861,37862,37863,37864,37865,37866,37867,37868,37869,37870,37871,37872,37873,37874,37875,37876,37877,37878,37879,37880,37881,37882,37883,37884,37885,37886,37887,37888,37889,37890,37891,37892,37893,37894,37895,37896,37897,37898,37899,37900,37901,37902,37903,37904,37905,37906,37907,37908,37909,37910,37911,37912,37913,37914,37915,37916,37917,37918,37919,37920,37921,37922,37923,37924,37925,37926,37927,37928,37929,37930,37931,37932,37933,37934,37935,37936,37937,37938,37939,37940,37941,37942,37943,37944,37945,37946,37947,37948,37949,37950,37951,37952,37953,37954,37955,37956,37957,37958,37959,37960,37961,37962,37963,37964,37965,37966,37967,37968,37969,37970,37971,37972,37973,37974,37975,37976,37977,37978,37979,37980,37981,37982,37983,37984,37985,37986,37987,37988,37989,37990,37991,37992,37993,37994,37995,37996,37997,37998,37999,38000,38001,38002,38003,38004,38005,38006,38007,38008,38009,38010,38011,38012,38013,38014,38015,38016,38017,38018,38019,38020,38021,38022,38023,38024,38025,38026,38027,38028,38029,38030,38031,38032,38033,38034,41998,41999,42000,42001,42002,42003,42004,42005,42006,42007,42008,43433,44434,44435,44436,44437,44438,44439,44440,44441,44442,44443,44444,44445,44446,44447,44448,44449,44450,44451,44452,44453,44454,44455,44456,44457,44458,44459,44460,44461,44462,44463,44464,44465,44466,44467,44468,44469,44470,44471,44472,44473,44474,44475,44476,44477,44478,44479,44480,44481,44482,44483,44484,44485,44486,44487,44488,44489,44490,44491,44528,45248,48949,53548,56124,60121,38424,38426,38427,38431,38434,38437,44074,44075,45508,50933,56034,59754,38428,38429,38433,38435,38436,44070,44071,44073,44076,44079,46595,38550,38551,47711,47712,67869,38552,38553,67633,38554,42383,54534,61067,38555,38556,38557,38558,38559,38794,38795,39728,40315,40316,44803,54625,54626,54627,40415,50934,50935,55772,55773,55774,41338,41339,41340,41341,42278,56033,42215,43325,45179,45180,45181,45182,45183,45184,45185,45186,45187,42276,42277,45507,43521,43522,43565,43566,44072,44100,44127,56002,56003,56008,60299,60300,60301,60302,60303,60304,60305,60306,60308,44804,47592,47593,47594,63169) [ RunTime:0.000486s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000446s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605,37373,37835,37836,37837,37838,37839,37840,37841,37842,37843,37844,37845,37846,37847,37848,37849,37850,37851,37852,37853,37854,37855,37856,37857,37858,37859,37860,37861,37862,37863,37864,37865,37866,37867,37868,37869,37870,37871,37872,37873,37874,37875,37876,37877,37878,37879,37880,37881,37882,37883,37884,37885,37886,37887,37888,37889,37890,37891,37892,37893,37894,37895,37896,37897,37898,37899,37900,37901,37902,37903,37904,37905,37906,37907,37908,37909,37910,37911,37912,37913,37914,37915,37916,37917,37918,37919,37920,37921,37922,37923,37924,37925,37926,37927,37928,37929,37930,37931,37932,37933,37934,37935,37936,37937,37938,37939,37940,37941,37942,37943,37944,37945,37946,37947,37948,37949,37950,37951,37952,37953,37954,37955,37956,37957,37958,37959,37960,37961,37962,37963,37964,37965,37966,37967,37968,37969,37970,37971,37972,37973,37974,37975,37976,37977,37978,37979,37980,37981,37982,37983,37984,37985,37986,37987,37988,37989,37990,37991,37992,37993,37994,37995,37996,37997,37998,37999,38000,38001,38002,38003,38004,38005,38006,38007,38008,38009,38010,38011,38012,38013,38014,38015,38016,38017,38018,38019,38020,38021,38022,38023,38024,38025,38026,38027,38028,38029,38030,38031,38032,38033,38034,41998,41999,42000,42001,42002,42003,42004,42005,42006,42007,42008,43433,44434,44435,44436,44437,44438,44439,44440,44441,44442,44443,44444,44445,44446,44447,44448,44449,44450,44451,44452,44453,44454,44455,44456,44457,44458,44459,44460,44461,44462,44463,44464,44465,44466,44467,44468,44469,44470,44471,44472,44473,44474,44475,44476,44477,44478,44479,44480,44481,44482,44483,44484,44485,44486,44487,44488,44489,44490,44491,44528,45248,48949,53548,56124,60121,38424,38426,38427,38431,38434,38437,44074,44075,45508,50933,56034,59754,38428,38429,38433,38435,38436,44070,44071,44073,44076,44079,46595,38550,38551,47711,47712,67869,38552,38553,67633,38554,42383,54534,61067,38555,38556,38557,38558,38559,38794,38795,39728,40315,40316,44803,54625,54626,54627,40415,50934,50935,55772,55773,55774,41338,41339,41340,41341,42278,56033,42215,43325,45179,45180,45181,45182,45183,45184,45185,45186,45187,42276,42277,45507,43521,43522,43565,43566,44072,44100,44127,56002,56003,56008,60299,60300,60301,60302,60303,60304,60305,60306,60308,44804,47592,47593,47594,63169) AND `attr_value` <> '' [ RunTime:0.003372s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000471s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000159s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605,37373,37835,37836,37837,37838,37839,37840,37841,37842,37843,37844,37845,37846,37847,37848,37849,37850,37851,37852,37853,37854,37855,37856,37857,37858,37859,37860,37861,37862,37863,37864,37865,37866,37867,37868,37869,37870,37871,37872,37873,37874,37875,37876,37877,37878,37879,37880,37881,37882,37883,37884,37885,37886,37887,37888,37889,37890,37891,37892,37893,37894,37895,37896,37897,37898,37899,37900,37901,37902,37903,37904,37905,37906,37907,37908,37909,37910,37911,37912,37913,37914,37915,37916,37917,37918,37919,37920,37921,37922,37923,37924,37925,37926,37927,37928,37929,37930,37931,37932,37933,37934,37935,37936,37937,37938,37939,37940,37941,37942,37943,37944,37945,37946,37947,37948,37949,37950,37951,37952,37953,37954,37955,37956,37957,37958,37959,37960,37961,37962,37963,37964,37965,37966,37967,37968,37969,37970,37971,37972,37973,37974,37975,37976,37977,37978,37979,37980,37981,37982,37983,37984,37985,37986,37987,37988,37989,37990,37991,37992,37993,37994,37995,37996,37997,37998,37999,38000,38001,38002,38003,38004,38005,38006,38007,38008,38009,38010,38011,38012,38013,38014,38015,38016,38017,38018,38019,38020,38021,38022,38023,38024,38025,38026,38027,38028,38029,38030,38031,38032,38033,38034,41998,41999,42000,42001,42002,42003,42004,42005,42006,42007,42008,43433,44434,44435,44436,44437,44438,44439,44440,44441,44442,44443,44444,44445,44446,44447,44448,44449,44450,44451,44452,44453,44454,44455,44456,44457,44458,44459,44460,44461,44462,44463,44464,44465,44466,44467,44468,44469,44470,44471,44472,44473,44474,44475,44476,44477,44478,44479,44480,44481,44482,44483,44484,44485,44486,44487,44488,44489,44490,44491,44528,45248,48949,53548,56124,60121,38424,38426,38427,38431,38434,38437,44074,44075,45508,50933,56034,59754,38428,38429,38433,38435,38436,44070,44071,44073,44076,44079,46595,38550,38551,47711,47712,67869,38552,38553,67633,38554,42383,54534,61067,38555,38556,38557,38558,38559,38794,38795,39728,40315,40316,44803,54625,54626,54627,40415,50934,50935,55772,55773,55774,41338,41339,41340,41341,42278,56033,42215,43325,45179,45180,45181,45182,45183,45184,45185,45186,45187,42276,42277,45507,43521,43522,43565,43566,44072,44100,44127,56002,56003,56008,60299,60300,60301,60302,60303,60304,60305,60306,60308,44804,47592,47593,47594,63169) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.017630s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000470s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (37373,37835,37836,37837,37838,37839,37840,37841,37842,37843) [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000400s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000136s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000244s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37373 LIMIT 1 [ RunTime:0.000241s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37835 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37836 LIMIT 1 [ RunTime:0.000320s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37837 LIMIT 1 [ RunTime:0.000309s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37838 LIMIT 1 [ RunTime:0.000751s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37839 LIMIT 1 [ RunTime:0.000246s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37840 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37841 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37842 LIMIT 1 [ RunTime:0.000207s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37843 LIMIT 1 [ RunTime:0.000225s ]
