SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.001309s ]
SELECT * FROM `tp_wx_user` WHERE ( w_token = "xkopzw1490691329" ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000840s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 342 LIMIT 1 [ RunTime:0.000219s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000195s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 342 [ RunTime:0.000164s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001489s ]
SELECT `shop_price` FROM `tp_goods` WHERE `goods_id` IN (179867,790,1522,1526,1530,2195,2291,2615,2834,2946,3431,3443,5091,5163,5165,5166,5481,5763,5832,5864,5866,5868,5991,6013,6056,6244,6248,6249,6253,6257,6369,6373,6384,6387,6400,6499,6601,7416,7747,7759,7764,8103,8105,8107,8129,8160,8185,8662,13783,13800,13804,13805,13824,13911,13913,14109,14110,14112,14113,14301,14567,15701,15708,15709,15714,15725,15807,16037,16039,16387,16390,16396,16408,16409,16410,16411,17704,19163,19164,19169,19230,19802,20288,21068,21069,21248,22771,23319,23320,23549,23550,23551,23709,25129,26319,26673,26867,28464,28465,28505,28864,28865,28866,28867,29516,29517,30435,30436,30510,30515,30516,30791,31059,31060,31067,31117,31905,31969,31978,33428,33757,33758,34691,34700,34984,34985,34986,35526,35527,35982,36054,36104,36184,36294,36295,36296,36297,36365,36366,37046,37048,37049,37055,38187,38188,38261,38856,38945,39909,39910,40001,40660,40661,40893,40933,40948,41334,41450,42657,42658,45560,45672,45673,45871,46109,47649,47686,52548,57099,58095,58173,58944,59272,61132,61191,61192,61194,61195,61663,61664,62057,62061,63260,65882,76567,76899,76936,77756,77758,78962,79329,79330,79331,79332,79333,79336,79472,79479,79480,79481,79486,79565,79571,79911,79985,80494,80677,81016,82989,86484,86864,86944,86945,87141,88005,88658,89590,90381,93819,95730,99802,101951,103483,103898,104172,104345,104433,106850,107153,107154,107155,107156,107157,107158,107159,107972,107981,108127,108483,108484,108527,108570,108572,108573,108574,108575,108586,109156,109633,109637,109664,110321,110410,110716,110795,110821,110827,112313,112314,112655,112721,112955,112956,112965,112969,112970,112971,112972,112973,112974,112975,112977,112978,112979,112980,112981,112984,112985,112986,112987,112988,112989,112991,112992,112993,112994,112995,112996,112997,112998,112999,113020,113829,113844,113864,113891,113892,113895,113896,113897,113898,113964,113973,113981,113982,113992,113993,114034,114050,114356,114357,114358,114359,114360,114361,114362,114363,114364,114365,114395,114581,114582,114583,114584,114585,114586,114587,114588,114589,114590,114591,114713,114714,114723,114784,114785,114859,115346,115562,115563,116135,116231,116540,116636,116652,116951,116955,117547,118251,118479,118775,119093,119121,119707,120887,121004,122605,125390,126276,126548,126571,126586,126590,126596,127430,127431,128304,128305,128763,129586,129587,130257,130787,130963,130964,132199,132207,132229,132231,132799,132800,133531,136078,137268,138054,139373,139374,139419,139563,139564,139933,146389,147211,147212,147390,149746,149747,149748,149749,149750,149755,149756,149760,149762,149763,149764,150359,150360,151557,151662,152631,152714,152717,152718,154308,154449,154450,154451,154656,159356,159357,159358,159361,159383,165244,166859,166861,166930,168012,168013,168369,169299,171981,171982,172883,173588,173794,174176,174483,176301,176521,176803,177237,177390,177858,177859,177860,177862,177863,177864,177865,177866,177870,177875,177880,177881,177883,177887,177888,177890,177891,177899,177900,177901,177980,177981,177984,177985,177986,177987,177988,177989,177991,178037,178039,178040,178041,178042,178043,178047,178048,178049,178050,178051,178054,178065,178067,178073,178074,179775,179841,179842,179849,179866,179868,179877,179878,179880,179881,180709,180710,180796,181169,181216,181218,181219,181392,182555,183678,183681,183682,184137,184147,184149,184156,184271,184272,186135,186136,186137,186138,186142,2935,4068,4690,5490,5751,6500,7750,7751,16422,16429,19121,20679,32395,34024,34200,36298,38186,38466,38868,39993,40007,40961,43282,58604,58605,59474,61271,63256,63259,79320,79477,91556,103932,108577,108578,108579,108588,108595,113010,114887,115919,116695,117864,121788,121939,127502,134710,149732,152715,152716,160387,177867,177896,178055,178057,179876,181231,183474,791,792,794,796,797,804,805,817,1531,1828,2053,2131,2413,2414,2453,2454,2610,2611,2612,2682,2837,2929,5017,5069,5095,5096,5097,5194,5204,5205,5494,5497,5499,5503,5872,5873,5992,5993,6245,7760,8028,8235,8666,13772,13787,13825,14108,14120,14122,15943,15998,16036,16397,16417,16418,16419,16420,16425,16427,16432,16435,16447,16478,18871,19165,19166,21240,21256,21611,22221,22782,22801,23321,24928,24929,26606,30384,30385,30861,30862,31070,31118,31119,33917,34171,34172,34199,34697,34887,34987,34988,34989,35523,36101,36183,36299,36300,36301,36552,37052,37740,37785,37786,37787,40009,40146,40501,40502,40953,40967,40968,41040,42659,44933,46064,46105,46350,46351,46404,46405,47694,58074,58091,58724,59411,61201,61263,63257,63258,66571,76900,76902,77751,77752,77753,79334,79335,79473,79474,79475,79476,79478,79907,80100,80152,82990,83002,85452,85453,85454,85744,85747,86713,86714,87565,89591,91443,91444,108184,108576,108584,108585,108587,108589,108590,108594,108596,109157,109187,110709,111103,111726,112317,112656,113000,113001,113002,113003,113008,113009,113017,113018,113019,113021,113849,113850,113863,113899,113900,113901,114293,114396,114620,114793,114818,114842,115561,116529,116549,116694,116791,116929,116949,117033,117865,118250,119094,119503,125272,126239,126578,131152,131153,131861,132598,137369,137421,139258,139259,139375,139376,139565,139580,139674,139685,139788,140809,143449,143568,144835,144836,144837,144843,146393,147374,149729,149730,149741,149742,149744,150334,152720,153255,154332,154333,154335,154336,157252,161863,166867,167917,168079,168370,168517,168950,171713,172740,176742,177871,177876,177879,177882,177889,177892,177894,177895,177898,177990,177993,177994,177996,177997,178033,178034,178035,178036,178046,178052,178056,178066,178068,178070,178071,178072,179020,180898,180907,181226,181230,182515,182526,184141,184145,184274,184363,184364,184369,186166,15703,18714,24331,35577,35578,35580,35581,35583,35584,35586,35710,36892,36893,37939,37941,37942,38561,38944,39301,80088,85637,85638,85639,85640,85641,85642,85643,108489,108490,108497,108499,108500,108501,108502,108597,108598,108599,108604,108605,109646,110787,110791,110792,110793,112961,112962,112963,112964,113056,114056,114430,114431,114669,116952,116954,132683,132805,132808,133571,138142,138148,146917,147396,167056,173963,178058,178059,178060,178061,178062,178063,178064,181235,179879,1059,1066,1068,1069,1070,16533,26999,27072,45776,45777,45778,122176,122460) [ RunTime:0.011933s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (179867,790,1522,1526,1530,2195,2291,2615,2834,2946,3431,3443,5091,5163,5165,5166,5481,5763,5832,5864,5866,5868,5991,6013,6056,6244,6248,6249,6253,6257,6369,6373,6384,6387,6400,6499,6601,7416,7747,7759,7764,8103,8105,8107,8129,8160,8185,8662,13783,13800,13804,13805,13824,13911,13913,14109,14110,14112,14113,14301,14567,15701,15708,15709,15714,15725,15807,16037,16039,16387,16390,16396,16408,16409,16410,16411,17704,19163,19164,19169,19230,19802,20288,21068,21069,21248,22771,23319,23320,23549,23550,23551,23709,25129,26319,26673,26867,28464,28465,28505,28864,28865,28866,28867,29516,29517,30435,30436,30510,30515,30516,30791,31059,31060,31067,31117,31905,31969,31978,33428,33757,33758,34691,34700,34984,34985,34986,35526,35527,35982,36054,36104,36184,36294,36295,36296,36297,36365,36366,37046,37048,37049,37055,38187,38188,38261,38856,38945,39909,39910,40001,40660,40661,40893,40933,40948,41334,41450,42657,42658,45560,45672,45673,45871,46109,47649,47686,52548,57099,58095,58173,58944,59272,61132,61191,61192,61194,61195,61663,61664,62057,62061,63260,65882,76567,76899,76936,77756,77758,78962,79329,79330,79331,79332,79333,79336,79472,79479,79480,79481,79486,79565,79571,79911,79985,80494,80677,81016,82989,86484,86864,86944,86945,87141,88005,88658,89590,90381,93819,95730,99802,101951,103483,103898,104172,104345,104433,106850,107153,107154,107155,107156,107157,107158,107159,107972,107981,108127,108483,108484,108527,108570,108572,108573,108574,108575,108586,109156,109633,109637,109664,110321,110410,110716,110795,110821,110827,112313,112314,112655,112721,112955,112956,112965,112969,112970,112971,112972,112973,112974,112975,112977,112978,112979,112980,112981,112984,112985,112986,112987,112988,112989,112991,112992,112993,112994,112995,112996,112997,112998,112999,113020,113829,113844,113864,113891,113892,113895,113896,113897,113898,113964,113973,113981,113982,113992,113993,114034,114050,114356,114357,114358,114359,114360,114361,114362,114363,114364,114365,114395,114581,114582,114583,114584,114585,114586,114587,114588,114589,114590,114591,114713,114714,114723,114784,114785,114859,115346,115562,115563,116135,116231,116540,116636,116652,116951,116955,117547,118251,118479,118775,119093,119121,119707,120887,121004,122605,125390,126276,126548,126571,126586,126590,126596,127430,127431,128304,128305,128763,129586,129587,130257,130787,130963,130964,132199,132207,132229,132231,132799,132800,133531,136078,137268,138054,139373,139374,139419,139563,139564,139933,146389,147211,147212,147390,149746,149747,149748,149749,149750,149755,149756,149760,149762,149763,149764,150359,150360,151557,151662,152631,152714,152717,152718,154308,154449,154450,154451,154656,159356,159357,159358,159361,159383,165244,166859,166861,166930,168012,168013,168369,169299,171981,171982,172883,173588,173794,174176,174483,176301,176521,176803,177237,177390,177858,177859,177860,177862,177863,177864,177865,177866,177870,177875,177880,177881,177883,177887,177888,177890,177891,177899,177900,177901,177980,177981,177984,177985,177986,177987,177988,177989,177991,178037,178039,178040,178041,178042,178043,178047,178048,178049,178050,178051,178054,178065,178067,178073,178074,179775,179841,179842,179849,179866,179868,179877,179878,179880,179881,180709,180710,180796,181169,181216,181218,181219,181392,182555,183678,183681,183682,184137,184147,184149,184156,184271,184272,186135,186136,186137,186138,186142,2935,4068,4690,5490,5751,6500,7750,7751,16422,16429,19121,20679,32395,34024,34200,36298,38186,38466,38868,39993,40007,40961,43282,58604,58605,59474,61271,63256,63259,79320,79477,91556,103932,108577,108578,108579,108588,108595,113010,114887,115919,116695,117864,121788,121939,127502,134710,149732,152715,152716,160387,177867,177896,178055,178057,179876,181231,183474,791,792,794,796,797,804,805,817,1531,1828,2053,2131,2413,2414,2453,2454,2610,2611,2612,2682,2837,2929,5017,5069,5095,5096,5097,5194,5204,5205,5494,5497,5499,5503,5872,5873,5992,5993,6245,7760,8028,8235,8666,13772,13787,13825,14108,14120,14122,15943,15998,16036,16397,16417,16418,16419,16420,16425,16427,16432,16435,16447,16478,18871,19165,19166,21240,21256,21611,22221,22782,22801,23321,24928,24929,26606,30384,30385,30861,30862,31070,31118,31119,33917,34171,34172,34199,34697,34887,34987,34988,34989,35523,36101,36183,36299,36300,36301,36552,37052,37740,37785,37786,37787,40009,40146,40501,40502,40953,40967,40968,41040,42659,44933,46064,46105,46350,46351,46404,46405,47694,58074,58091,58724,59411,61201,61263,63257,63258,66571,76900,76902,77751,77752,77753,79334,79335,79473,79474,79475,79476,79478,79907,80100,80152,82990,83002,85452,85453,85454,85744,85747,86713,86714,87565,89591,91443,91444,108184,108576,108584,108585,108587,108589,108590,108594,108596,109157,109187,110709,111103,111726,112317,112656,113000,113001,113002,113003,113008,113009,113017,113018,113019,113021,113849,113850,113863,113899,113900,113901,114293,114396,114620,114793,114818,114842,115561,116529,116549,116694,116791,116929,116949,117033,117865,118250,119094,119503,125272,126239,126578,131152,131153,131861,132598,137369,137421,139258,139259,139375,139376,139565,139580,139674,139685,139788,140809,143449,143568,144835,144836,144837,144843,146393,147374,149729,149730,149741,149742,149744,150334,152720,153255,154332,154333,154335,154336,157252,161863,166867,167917,168079,168370,168517,168950,171713,172740,176742,177871,177876,177879,177882,177889,177892,177894,177895,177898,177990,177993,177994,177996,177997,178033,178034,178035,178036,178046,178052,178056,178066,178068,178070,178071,178072,179020,180898,180907,181226,181230,182515,182526,184141,184145,184274,184363,184364,184369,186166,15703,18714,24331,35577,35578,35580,35581,35583,35584,35586,35710,36892,36893,37939,37941,37942,38561,38944,39301,80088,85637,85638,85639,85640,85641,85642,85643,108489,108490,108497,108499,108500,108501,108502,108597,108598,108599,108604,108605,109646,110787,110791,110792,110793,112961,112962,112963,112964,113056,114056,114430,114431,114669,116952,116954,132683,132805,132808,133571,138142,138148,146917,147396,167056,173963,178058,178059,178060,178061,178062,178063,178064,181235,179879,1059,1066,1068,1069,1070,16533,26999,27072,45776,45777,45778,122176,122460) AND `brand_id` > 0 [ RunTime:0.011311s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000933s ]
SELECT * FROM `tp_brand` WHERE `id` IN (30,18,89,22,93,31,55,60,19,188,204,221,203,303,236,245,223,246,27,241,251) LIMIT 30 [ RunTime:0.000280s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(179867,790,1522,1526,1530,2195,2291,2615,2834,2946,3431,3443,5091,5163,5165,5166,5481,5763,5832,5864,5866,5868,5991,6013,6056,6244,6248,6249,6253,6257,6369,6373,6384,6387,6400,6499,6601,7416,7747,7759,7764,8103,8105,8107,8129,8160,8185,8662,13783,13800,13804,13805,13824,13911,13913,14109,14110,14112,14113,14301,14567,15701,15708,15709,15714,15725,15807,16037,16039,16387,16390,16396,16408,16409,16410,16411,17704,19163,19164,19169,19230,19802,20288,21068,21069,21248,22771,23319,23320,23549,23550,23551,23709,25129,26319,26673,26867,28464,28465,28505,28864,28865,28866,28867,29516,29517,30435,30436,30510,30515,30516,30791,31059,31060,31067,31117,31905,31969,31978,33428,33757,33758,34691,34700,34984,34985,34986,35526,35527,35982,36054,36104,36184,36294,36295,36296,36297,36365,36366,37046,37048,37049,37055,38187,38188,38261,38856,38945,39909,39910,40001,40660,40661,40893,40933,40948,41334,41450,42657,42658,45560,45672,45673,45871,46109,47649,47686,52548,57099,58095,58173,58944,59272,61132,61191,61192,61194,61195,61663,61664,62057,62061,63260,65882,76567,76899,76936,77756,77758,78962,79329,79330,79331,79332,79333,79336,79472,79479,79480,79481,79486,79565,79571,79911,79985,80494,80677,81016,82989,86484,86864,86944,86945,87141,88005,88658,89590,90381,93819,95730,99802,101951,103483,103898,104172,104345,104433,106850,107153,107154,107155,107156,107157,107158,107159,107972,107981,108127,108483,108484,108527,108570,108572,108573,108574,108575,108586,109156,109633,109637,109664,110321,110410,110716,110795,110821,110827,112313,112314,112655,112721,112955,112956,112965,112969,112970,112971,112972,112973,112974,112975,112977,112978,112979,112980,112981,112984,112985,112986,112987,112988,112989,112991,112992,112993,112994,112995,112996,112997,112998,112999,113020,113829,113844,113864,113891,113892,113895,113896,113897,113898,113964,113973,113981,113982,113992,113993,114034,114050,114356,114357,114358,114359,114360,114361,114362,114363,114364,114365,114395,114581,114582,114583,114584,114585,114586,114587,114588,114589,114590,114591,114713,114714,114723,114784,114785,114859,115346,115562,115563,116135,116231,116540,116636,116652,116951,116955,117547,118251,118479,118775,119093,119121,119707,120887,121004,122605,125390,126276,126548,126571,126586,126590,126596,127430,127431,128304,128305,128763,129586,129587,130257,130787,130963,130964,132199,132207,132229,132231,132799,132800,133531,136078,137268,138054,139373,139374,139419,139563,139564,139933,146389,147211,147212,147390,149746,149747,149748,149749,149750,149755,149756,149760,149762,149763,149764,150359,150360,151557,151662,152631,152714,152717,152718,154308,154449,154450,154451,154656,159356,159357,159358,159361,159383,165244,166859,166861,166930,168012,168013,168369,169299,171981,171982,172883,173588,173794,174176,174483,176301,176521,176803,177237,177390,177858,177859,177860,177862,177863,177864,177865,177866,177870,177875,177880,177881,177883,177887,177888,177890,177891,177899,177900,177901,177980,177981,177984,177985,177986,177987,177988,177989,177991,178037,178039,178040,178041,178042,178043,178047,178048,178049,178050,178051,178054,178065,178067,178073,178074,179775,179841,179842,179849,179866,179868,179877,179878,179880,179881,180709,180710,180796,181169,181216,181218,181219,181392,182555,183678,183681,183682,184137,184147,184149,184156,184271,184272,186135,186136,186137,186138,186142,2935,4068,4690,5490,5751,6500,7750,7751,16422,16429,19121,20679,32395,34024,34200,36298,38186,38466,38868,39993,40007,40961,43282,58604,58605,59474,61271,63256,63259,79320,79477,91556,103932,108577,108578,108579,108588,108595,113010,114887,115919,116695,117864,121788,121939,127502,134710,149732,152715,152716,160387,177867,177896,178055,178057,179876,181231,183474,791,792,794,796,797,804,805,817,1531,1828,2053,2131,2413,2414,2453,2454,2610,2611,2612,2682,2837,2929,5017,5069,5095,5096,5097,5194,5204,5205,5494,5497,5499,5503,5872,5873,5992,5993,6245,7760,8028,8235,8666,13772,13787,13825,14108,14120,14122,15943,15998,16036,16397,16417,16418,16419,16420,16425,16427,16432,16435,16447,16478,18871,19165,19166,21240,21256,21611,22221,22782,22801,23321,24928,24929,26606,30384,30385,30861,30862,31070,31118,31119,33917,34171,34172,34199,34697,34887,34987,34988,34989,35523,36101,36183,36299,36300,36301,36552,37052,37740,37785,37786,37787,40009,40146,40501,40502,40953,40967,40968,41040,42659,44933,46064,46105,46350,46351,46404,46405,47694,58074,58091,58724,59411,61201,61263,63257,63258,66571,76900,76902,77751,77752,77753,79334,79335,79473,79474,79475,79476,79478,79907,80100,80152,82990,83002,85452,85453,85454,85744,85747,86713,86714,87565,89591,91443,91444,108184,108576,108584,108585,108587,108589,108590,108594,108596,109157,109187,110709,111103,111726,112317,112656,113000,113001,113002,113003,113008,113009,113017,113018,113019,113021,113849,113850,113863,113899,113900,113901,114293,114396,114620,114793,114818,114842,115561,116529,116549,116694,116791,116929,116949,117033,117865,118250,119094,119503,125272,126239,126578,131152,131153,131861,132598,137369,137421,139258,139259,139375,139376,139565,139580,139674,139685,139788,140809,143449,143568,144835,144836,144837,144843,146393,147374,149729,149730,149741,149742,149744,150334,152720,153255,154332,154333,154335,154336,157252,161863,166867,167917,168079,168370,168517,168950,171713,172740,176742,177871,177876,177879,177882,177889,177892,177894,177895,177898,177990,177993,177994,177996,177997,178033,178034,178035,178036,178046,178052,178056,178066,178068,178070,178071,178072,179020,180898,180907,181226,181230,182515,182526,184141,184145,184274,184363,184364,184369,186166,15703,18714,24331,35577,35578,35580,35581,35583,35584,35586,35710,36892,36893,37939,37941,37942,38561,38944,39301,80088,85637,85638,85639,85640,85641,85642,85643,108489,108490,108497,108499,108500,108501,108502,108597,108598,108599,108604,108605,109646,110787,110791,110792,110793,112961,112962,112963,112964,113056,114056,114430,114431,114669,116952,116954,132683,132805,132808,133571,138142,138148,146917,147396,167056,173963,178058,178059,178060,178061,178062,178063,178064,181235,179879,1059,1066,1068,1069,1070,16533,26999,27072,45776,45777,45778,122176,122460) [ RunTime:0.000770s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000730s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (179867,790,1522,1526,1530,2195,2291,2615,2834,2946,3431,3443,5091,5163,5165,5166,5481,5763,5832,5864,5866,5868,5991,6013,6056,6244,6248,6249,6253,6257,6369,6373,6384,6387,6400,6499,6601,7416,7747,7759,7764,8103,8105,8107,8129,8160,8185,8662,13783,13800,13804,13805,13824,13911,13913,14109,14110,14112,14113,14301,14567,15701,15708,15709,15714,15725,15807,16037,16039,16387,16390,16396,16408,16409,16410,16411,17704,19163,19164,19169,19230,19802,20288,21068,21069,21248,22771,23319,23320,23549,23550,23551,23709,25129,26319,26673,26867,28464,28465,28505,28864,28865,28866,28867,29516,29517,30435,30436,30510,30515,30516,30791,31059,31060,31067,31117,31905,31969,31978,33428,33757,33758,34691,34700,34984,34985,34986,35526,35527,35982,36054,36104,36184,36294,36295,36296,36297,36365,36366,37046,37048,37049,37055,38187,38188,38261,38856,38945,39909,39910,40001,40660,40661,40893,40933,40948,41334,41450,42657,42658,45560,45672,45673,45871,46109,47649,47686,52548,57099,58095,58173,58944,59272,61132,61191,61192,61194,61195,61663,61664,62057,62061,63260,65882,76567,76899,76936,77756,77758,78962,79329,79330,79331,79332,79333,79336,79472,79479,79480,79481,79486,79565,79571,79911,79985,80494,80677,81016,82989,86484,86864,86944,86945,87141,88005,88658,89590,90381,93819,95730,99802,101951,103483,103898,104172,104345,104433,106850,107153,107154,107155,107156,107157,107158,107159,107972,107981,108127,108483,108484,108527,108570,108572,108573,108574,108575,108586,109156,109633,109637,109664,110321,110410,110716,110795,110821,110827,112313,112314,112655,112721,112955,112956,112965,112969,112970,112971,112972,112973,112974,112975,112977,112978,112979,112980,112981,112984,112985,112986,112987,112988,112989,112991,112992,112993,112994,112995,112996,112997,112998,112999,113020,113829,113844,113864,113891,113892,113895,113896,113897,113898,113964,113973,113981,113982,113992,113993,114034,114050,114356,114357,114358,114359,114360,114361,114362,114363,114364,114365,114395,114581,114582,114583,114584,114585,114586,114587,114588,114589,114590,114591,114713,114714,114723,114784,114785,114859,115346,115562,115563,116135,116231,116540,116636,116652,116951,116955,117547,118251,118479,118775,119093,119121,119707,120887,121004,122605,125390,126276,126548,126571,126586,126590,126596,127430,127431,128304,128305,128763,129586,129587,130257,130787,130963,130964,132199,132207,132229,132231,132799,132800,133531,136078,137268,138054,139373,139374,139419,139563,139564,139933,146389,147211,147212,147390,149746,149747,149748,149749,149750,149755,149756,149760,149762,149763,149764,150359,150360,151557,151662,152631,152714,152717,152718,154308,154449,154450,154451,154656,159356,159357,159358,159361,159383,165244,166859,166861,166930,168012,168013,168369,169299,171981,171982,172883,173588,173794,174176,174483,176301,176521,176803,177237,177390,177858,177859,177860,177862,177863,177864,177865,177866,177870,177875,177880,177881,177883,177887,177888,177890,177891,177899,177900,177901,177980,177981,177984,177985,177986,177987,177988,177989,177991,178037,178039,178040,178041,178042,178043,178047,178048,178049,178050,178051,178054,178065,178067,178073,178074,179775,179841,179842,179849,179866,179868,179877,179878,179880,179881,180709,180710,180796,181169,181216,181218,181219,181392,182555,183678,183681,183682,184137,184147,184149,184156,184271,184272,186135,186136,186137,186138,186142,2935,4068,4690,5490,5751,6500,7750,7751,16422,16429,19121,20679,32395,34024,34200,36298,38186,38466,38868,39993,40007,40961,43282,58604,58605,59474,61271,63256,63259,79320,79477,91556,103932,108577,108578,108579,108588,108595,113010,114887,115919,116695,117864,121788,121939,127502,134710,149732,152715,152716,160387,177867,177896,178055,178057,179876,181231,183474,791,792,794,796,797,804,805,817,1531,1828,2053,2131,2413,2414,2453,2454,2610,2611,2612,2682,2837,2929,5017,5069,5095,5096,5097,5194,5204,5205,5494,5497,5499,5503,5872,5873,5992,5993,6245,7760,8028,8235,8666,13772,13787,13825,14108,14120,14122,15943,15998,16036,16397,16417,16418,16419,16420,16425,16427,16432,16435,16447,16478,18871,19165,19166,21240,21256,21611,22221,22782,22801,23321,24928,24929,26606,30384,30385,30861,30862,31070,31118,31119,33917,34171,34172,34199,34697,34887,34987,34988,34989,35523,36101,36183,36299,36300,36301,36552,37052,37740,37785,37786,37787,40009,40146,40501,40502,40953,40967,40968,41040,42659,44933,46064,46105,46350,46351,46404,46405,47694,58074,58091,58724,59411,61201,61263,63257,63258,66571,76900,76902,77751,77752,77753,79334,79335,79473,79474,79475,79476,79478,79907,80100,80152,82990,83002,85452,85453,85454,85744,85747,86713,86714,87565,89591,91443,91444,108184,108576,108584,108585,108587,108589,108590,108594,108596,109157,109187,110709,111103,111726,112317,112656,113000,113001,113002,113003,113008,113009,113017,113018,113019,113021,113849,113850,113863,113899,113900,113901,114293,114396,114620,114793,114818,114842,115561,116529,116549,116694,116791,116929,116949,117033,117865,118250,119094,119503,125272,126239,126578,131152,131153,131861,132598,137369,137421,139258,139259,139375,139376,139565,139580,139674,139685,139788,140809,143449,143568,144835,144836,144837,144843,146393,147374,149729,149730,149741,149742,149744,150334,152720,153255,154332,154333,154335,154336,157252,161863,166867,167917,168079,168370,168517,168950,171713,172740,176742,177871,177876,177879,177882,177889,177892,177894,177895,177898,177990,177993,177994,177996,177997,178033,178034,178035,178036,178046,178052,178056,178066,178068,178070,178071,178072,179020,180898,180907,181226,181230,182515,182526,184141,184145,184274,184363,184364,184369,186166,15703,18714,24331,35577,35578,35580,35581,35583,35584,35586,35710,36892,36893,37939,37941,37942,38561,38944,39301,80088,85637,85638,85639,85640,85641,85642,85643,108489,108490,108497,108499,108500,108501,108502,108597,108598,108599,108604,108605,109646,110787,110791,110792,110793,112961,112962,112963,112964,113056,114056,114430,114431,114669,116952,116954,132683,132805,132808,133571,138142,138148,146917,147396,167056,173963,178058,178059,178060,178061,178062,178063,178064,181235,179879,1059,1066,1068,1069,1070,16533,26999,27072,45776,45777,45778,122176,122460) AND `attr_value` <> '' [ RunTime:0.004892s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000640s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000174s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (179867,790,1522,1526,1530,2195,2291,2615,2834,2946,3431,3443,5091,5163,5165,5166,5481,5763,5832,5864,5866,5868,5991,6013,6056,6244,6248,6249,6253,6257,6369,6373,6384,6387,6400,6499,6601,7416,7747,7759,7764,8103,8105,8107,8129,8160,8185,8662,13783,13800,13804,13805,13824,13911,13913,14109,14110,14112,14113,14301,14567,15701,15708,15709,15714,15725,15807,16037,16039,16387,16390,16396,16408,16409,16410,16411,17704,19163,19164,19169,19230,19802,20288,21068,21069,21248,22771,23319,23320,23549,23550,23551,23709,25129,26319,26673,26867,28464,28465,28505,28864,28865,28866,28867,29516,29517,30435,30436,30510,30515,30516,30791,31059,31060,31067,31117,31905,31969,31978,33428,33757,33758,34691,34700,34984,34985,34986,35526,35527,35982,36054,36104,36184,36294,36295,36296,36297,36365,36366,37046,37048,37049,37055,38187,38188,38261,38856,38945,39909,39910,40001,40660,40661,40893,40933,40948,41334,41450,42657,42658,45560,45672,45673,45871,46109,47649,47686,52548,57099,58095,58173,58944,59272,61132,61191,61192,61194,61195,61663,61664,62057,62061,63260,65882,76567,76899,76936,77756,77758,78962,79329,79330,79331,79332,79333,79336,79472,79479,79480,79481,79486,79565,79571,79911,79985,80494,80677,81016,82989,86484,86864,86944,86945,87141,88005,88658,89590,90381,93819,95730,99802,101951,103483,103898,104172,104345,104433,106850,107153,107154,107155,107156,107157,107158,107159,107972,107981,108127,108483,108484,108527,108570,108572,108573,108574,108575,108586,109156,109633,109637,109664,110321,110410,110716,110795,110821,110827,112313,112314,112655,112721,112955,112956,112965,112969,112970,112971,112972,112973,112974,112975,112977,112978,112979,112980,112981,112984,112985,112986,112987,112988,112989,112991,112992,112993,112994,112995,112996,112997,112998,112999,113020,113829,113844,113864,113891,113892,113895,113896,113897,113898,113964,113973,113981,113982,113992,113993,114034,114050,114356,114357,114358,114359,114360,114361,114362,114363,114364,114365,114395,114581,114582,114583,114584,114585,114586,114587,114588,114589,114590,114591,114713,114714,114723,114784,114785,114859,115346,115562,115563,116135,116231,116540,116636,116652,116951,116955,117547,118251,118479,118775,119093,119121,119707,120887,121004,122605,125390,126276,126548,126571,126586,126590,126596,127430,127431,128304,128305,128763,129586,129587,130257,130787,130963,130964,132199,132207,132229,132231,132799,132800,133531,136078,137268,138054,139373,139374,139419,139563,139564,139933,146389,147211,147212,147390,149746,149747,149748,149749,149750,149755,149756,149760,149762,149763,149764,150359,150360,151557,151662,152631,152714,152717,152718,154308,154449,154450,154451,154656,159356,159357,159358,159361,159383,165244,166859,166861,166930,168012,168013,168369,169299,171981,171982,172883,173588,173794,174176,174483,176301,176521,176803,177237,177390,177858,177859,177860,177862,177863,177864,177865,177866,177870,177875,177880,177881,177883,177887,177888,177890,177891,177899,177900,177901,177980,177981,177984,177985,177986,177987,177988,177989,177991,178037,178039,178040,178041,178042,178043,178047,178048,178049,178050,178051,178054,178065,178067,178073,178074,179775,179841,179842,179849,179866,179868,179877,179878,179880,179881,180709,180710,180796,181169,181216,181218,181219,181392,182555,183678,183681,183682,184137,184147,184149,184156,184271,184272,186135,186136,186137,186138,186142,2935,4068,4690,5490,5751,6500,7750,7751,16422,16429,19121,20679,32395,34024,34200,36298,38186,38466,38868,39993,40007,40961,43282,58604,58605,59474,61271,63256,63259,79320,79477,91556,103932,108577,108578,108579,108588,108595,113010,114887,115919,116695,117864,121788,121939,127502,134710,149732,152715,152716,160387,177867,177896,178055,178057,179876,181231,183474,791,792,794,796,797,804,805,817,1531,1828,2053,2131,2413,2414,2453,2454,2610,2611,2612,2682,2837,2929,5017,5069,5095,5096,5097,5194,5204,5205,5494,5497,5499,5503,5872,5873,5992,5993,6245,7760,8028,8235,8666,13772,13787,13825,14108,14120,14122,15943,15998,16036,16397,16417,16418,16419,16420,16425,16427,16432,16435,16447,16478,18871,19165,19166,21240,21256,21611,22221,22782,22801,23321,24928,24929,26606,30384,30385,30861,30862,31070,31118,31119,33917,34171,34172,34199,34697,34887,34987,34988,34989,35523,36101,36183,36299,36300,36301,36552,37052,37740,37785,37786,37787,40009,40146,40501,40502,40953,40967,40968,41040,42659,44933,46064,46105,46350,46351,46404,46405,47694,58074,58091,58724,59411,61201,61263,63257,63258,66571,76900,76902,77751,77752,77753,79334,79335,79473,79474,79475,79476,79478,79907,80100,80152,82990,83002,85452,85453,85454,85744,85747,86713,86714,87565,89591,91443,91444,108184,108576,108584,108585,108587,108589,108590,108594,108596,109157,109187,110709,111103,111726,112317,112656,113000,113001,113002,113003,113008,113009,113017,113018,113019,113021,113849,113850,113863,113899,113900,113901,114293,114396,114620,114793,114818,114842,115561,116529,116549,116694,116791,116929,116949,117033,117865,118250,119094,119503,125272,126239,126578,131152,131153,131861,132598,137369,137421,139258,139259,139375,139376,139565,139580,139674,139685,139788,140809,143449,143568,144835,144836,144837,144843,146393,147374,149729,149730,149741,149742,149744,150334,152720,153255,154332,154333,154335,154336,157252,161863,166867,167917,168079,168370,168517,168950,171713,172740,176742,177871,177876,177879,177882,177889,177892,177894,177895,177898,177990,177993,177994,177996,177997,178033,178034,178035,178036,178046,178052,178056,178066,178068,178070,178071,178072,179020,180898,180907,181226,181230,182515,182526,184141,184145,184274,184363,184364,184369,186166,15703,18714,24331,35577,35578,35580,35581,35583,35584,35586,35710,36892,36893,37939,37941,37942,38561,38944,39301,80088,85637,85638,85639,85640,85641,85642,85643,108489,108490,108497,108499,108500,108501,108502,108597,108598,108599,108604,108605,109646,110787,110791,110792,110793,112961,112962,112963,112964,113056,114056,114430,114431,114669,116952,116954,132683,132805,132808,133571,138142,138148,146917,147396,167056,173963,178058,178059,178060,178061,178062,178063,178064,181235,179879,1059,1066,1068,1069,1070,16533,26999,27072,45776,45777,45778,122176,122460) ORDER BY `sort` ASC LIMIT 420,20 [ RunTime:0.009447s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000589s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (34171,178043,113019,159356,34172,165244,110716,113020,159357,33917,113021,79486,15998,159358,35710,178046,183678,126590,178047,178048) [ RunTime:0.000428s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000167s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000518s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000528s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000170s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000147s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000152s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000146s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000149s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000132s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000144s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000142s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000133s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000117s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000128s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000129s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000128s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000125s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000133s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000127s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000144s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000127s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000136s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000139s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000138s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000127s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000138s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000145s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000139s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000125s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000142s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000148s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000145s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000141s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1746381600 and end_time > 1746381600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000147s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000135s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 590 LIMIT 1 [ RunTime:0.000220s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1072 LIMIT 1 [ RunTime:0.000217s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 8138 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 17704 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 79502 LIMIT 1 [ RunTime:0.000192s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34171 LIMIT 1 [ RunTime:0.000186s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178043 LIMIT 1 [ RunTime:0.000190s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 113019 LIMIT 1 [ RunTime:0.000177s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 159356 LIMIT 1 [ RunTime:0.000182s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34172 LIMIT 1 [ RunTime:0.000221s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 165244 LIMIT 1 [ RunTime:0.000187s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 110716 LIMIT 1 [ RunTime:0.000173s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 159357 LIMIT 1 [ RunTime:0.000176s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33917 LIMIT 1 [ RunTime:0.000170s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 113021 LIMIT 1 [ RunTime:0.000183s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 79486 LIMIT 1 [ RunTime:0.000177s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 15998 LIMIT 1 [ RunTime:0.000180s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 159358 LIMIT 1 [ RunTime:0.000179s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35710 LIMIT 1 [ RunTime:0.000167s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178046 LIMIT 1 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 183678 LIMIT 1 [ RunTime:0.000182s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 126590 LIMIT 1 [ RunTime:0.000187s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178047 LIMIT 1 [ RunTime:0.000165s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 178048 LIMIT 1 [ RunTime:0.000171s ]
select * from `tp_slogan` [ RunTime:0.000117s ]
select * from `tp_article` where cat_id = 1 and is_open=1 limit 5 [ RunTime:0.000137s ]
select * from `tp_article` where cat_id = 2 and is_open=1 limit 5 [ RunTime:0.000126s ]
select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000127s ]
select * from `tp_article` where cat_id = 4 and is_open=1 limit 5 [ RunTime:0.000144s ]
select * from `tp_article` where cat_id = 5 and is_open=1 limit 5 [ RunTime:0.000142s ]
