SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.000647s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.000366s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.000156s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000470s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.000160s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000470s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1459 LIMIT 1 [ RunTime:0.000225s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000392s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1459 [ RunTime:0.000208s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000672s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (37062,37750,38311,39618,49160,50228,55702,55704,55705,55706,55777,61046,61203,63805,63813,63817,63922,37762,49656,40358,44306,52174,52266,52827,57060,33367,34506,37064,38952,39017,39459,40352,41448,33406,33408,33410,33361,35640,42889,53613,58469,39458,33300,39457,42900,42916,33280,58046,33261,33267,33271,33282,33291,33296,35799,37063,38353,38869,38948,41690,41951,41975,42328,42408,42553,42674,42800,42810,42890,43125,43212,43215,43216,43299,43300,43528,43770,43835,43983,44235,45903,46180,47453,47949,51232,51532,52796,53007,53039,53125,53812,58658,33255,33902,36065,39081,41417,41418,42774,44115,44366,44616,56195,56690,57931,58118,62429,42786,45343,45344,45345,33017,33038,33041,33044,33046,41756,41791,42275,42551,42573,42605,42608,42611,43918,56261,46936,59316,38882,47180,47239,43644,43645,43646,43647,43648,43649,52263,43837,43179,65541,51121,43752,43070,50164,50165,45170,45711,45712,35871,41113,41406,41778,41779,41955,42203,42434,42521,42522,42703,42752,42753,44063,44878,44990,44991,45911,45915,46885,46889,46891,47086,47128,49056,49113,49362,49367,49372,50486,50917,50918,50919,50920,50921,50943,50944,50945,50946,50947,50996,50997,50998,50999,51000,51003,51349,51354,51355,51356,51357,51358,51529,52215,52291,52292,52533,52534,52574,52575,52576,52577,52578,52579,52580,52581,52582,52583,52584,52585,52586,52587,52588,52589,52590,52634,52638,52677,52751,52753,52754,52755,52756,53142,53191,53280,53281,53377,53422,53423,53644,53873,54288,54770,54882,54934,54936,55028,55060,55071,55074,55292,55388,55390,55391,55393,55394,55395,55396,55397,55398,55399,55400,55401,55402,55635,55636,55637,55638,55639,55640,55641,56205,56475,56480,56493,56494,56495,56496,56514,56515,56672,56731,56773,56774,56775,56776,56777,56778,56779,56780,56781,56784,56785,56786,56789,56790,56791,56792,57075,57078,57079,57081,57082,57083,57086,57136,57264,57265,57266,57339,57615,57686,57687,57713,57875,58412,58413,58414,58415,58416,58417,58517,58518,58521,58524,58525,58526,58528,58529,58530,58531,58532,58533,58534,58535,58536,58660,58661,58718,58720,58722,58723,58724,58725,58726,58727,58960,58961,58962,58963,59007,59196,59222,59223,59224,59225,59247,59303,59304,59639,59640,60064,60161,63947,66496,66497,66513,66603,66605,66651,66828,33136,33140,33142,35805,35811,36166,37180,40140,44102,52942,52944,52945,52948,52961,52966,52969,52974,52975,53629,53655,53897,53898,53900,53914,53917,53918,53919,53920,56685,35819,48020,51837,52095,52096,52097,52098,52136,52681,39089,39768,41315,41740,43688,44411,47392,48017,52678,52679,56693,56783,58072,41179,41180,49874,33899,33900,46238,46350,46351,47156,49371,33901,41316,45723,51157,41834,41835,45913,47348,49360,49361,52050,52664,52665,52666,52667,56733,40258,46573,46574,46609,51752,52660,55392,56234,56659,56673,56674,57491,57492,57493,57666,35867,42013,47155,49012,52752,52757,55293,56476,52074,52076,52078,52079,55687,57730,40395,45759,43982,55284,55286,56040,33126,45335,52477,37752,37753,38310,39456,39617,54005,54031,54034,54036,54037,61202,38865,39557,42947,43250,47407,38855,42352,45350,45351,45764,46572,46594,46748,47413,49366,49877,50364,51541,52559,52560,52680,52748,53144,53145,54391,56757,57076,57077,57080,59014,65781,68292,38859,41129,45914,45917,46890,46892,49112,49365,51910,52682,52758,53874,55072,55073,55389,56238,56787,56788,57084,57085,57207,58783,39517,40825,41130,43446,47320,47850,62878,41131,42324,44050,46477,42895,47588,49111,57424,57561,57667,58368,51978,52541,55686,55700,59321,59322,59323,59326,59336,61233,61383,48720,49779,57652) [ RunTime:0.002091s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (37062,37750,38311,39618,49160,50228,55702,55704,55705,55706,55777,61046,61203,63805,63813,63817,63922,37762,49656,40358,44306,52174,52266,52827,57060,33367,34506,37064,38952,39017,39459,40352,41448,33406,33408,33410,33361,35640,42889,53613,58469,39458,33300,39457,42900,42916,33280,58046,33261,33267,33271,33282,33291,33296,35799,37063,38353,38869,38948,41690,41951,41975,42328,42408,42553,42674,42800,42810,42890,43125,43212,43215,43216,43299,43300,43528,43770,43835,43983,44235,45903,46180,47453,47949,51232,51532,52796,53007,53039,53125,53812,58658,33255,33902,36065,39081,41417,41418,42774,44115,44366,44616,56195,56690,57931,58118,62429,42786,45343,45344,45345,33017,33038,33041,33044,33046,41756,41791,42275,42551,42573,42605,42608,42611,43918,56261,46936,59316,38882,47180,47239,43644,43645,43646,43647,43648,43649,52263,43837,43179,65541,51121,43752,43070,50164,50165,45170,45711,45712,35871,41113,41406,41778,41779,41955,42203,42434,42521,42522,42703,42752,42753,44063,44878,44990,44991,45911,45915,46885,46889,46891,47086,47128,49056,49113,49362,49367,49372,50486,50917,50918,50919,50920,50921,50943,50944,50945,50946,50947,50996,50997,50998,50999,51000,51003,51349,51354,51355,51356,51357,51358,51529,52215,52291,52292,52533,52534,52574,52575,52576,52577,52578,52579,52580,52581,52582,52583,52584,52585,52586,52587,52588,52589,52590,52634,52638,52677,52751,52753,52754,52755,52756,53142,53191,53280,53281,53377,53422,53423,53644,53873,54288,54770,54882,54934,54936,55028,55060,55071,55074,55292,55388,55390,55391,55393,55394,55395,55396,55397,55398,55399,55400,55401,55402,55635,55636,55637,55638,55639,55640,55641,56205,56475,56480,56493,56494,56495,56496,56514,56515,56672,56731,56773,56774,56775,56776,56777,56778,56779,56780,56781,56784,56785,56786,56789,56790,56791,56792,57075,57078,57079,57081,57082,57083,57086,57136,57264,57265,57266,57339,57615,57686,57687,57713,57875,58412,58413,58414,58415,58416,58417,58517,58518,58521,58524,58525,58526,58528,58529,58530,58531,58532,58533,58534,58535,58536,58660,58661,58718,58720,58722,58723,58724,58725,58726,58727,58960,58961,58962,58963,59007,59196,59222,59223,59224,59225,59247,59303,59304,59639,59640,60064,60161,63947,66496,66497,66513,66603,66605,66651,66828,33136,33140,33142,35805,35811,36166,37180,40140,44102,52942,52944,52945,52948,52961,52966,52969,52974,52975,53629,53655,53897,53898,53900,53914,53917,53918,53919,53920,56685,35819,48020,51837,52095,52096,52097,52098,52136,52681,39089,39768,41315,41740,43688,44411,47392,48017,52678,52679,56693,56783,58072,41179,41180,49874,33899,33900,46238,46350,46351,47156,49371,33901,41316,45723,51157,41834,41835,45913,47348,49360,49361,52050,52664,52665,52666,52667,56733,40258,46573,46574,46609,51752,52660,55392,56234,56659,56673,56674,57491,57492,57493,57666,35867,42013,47155,49012,52752,52757,55293,56476,52074,52076,52078,52079,55687,57730,40395,45759,43982,55284,55286,56040,33126,45335,52477,37752,37753,38310,39456,39617,54005,54031,54034,54036,54037,61202,38865,39557,42947,43250,47407,38855,42352,45350,45351,45764,46572,46594,46748,47413,49366,49877,50364,51541,52559,52560,52680,52748,53144,53145,54391,56757,57076,57077,57080,59014,65781,68292,38859,41129,45914,45917,46890,46892,49112,49365,51910,52682,52758,53874,55072,55073,55389,56238,56787,56788,57084,57085,57207,58783,39517,40825,41130,43446,47320,47850,62878,41131,42324,44050,46477,42895,47588,49111,57424,57561,57667,58368,51978,52541,55686,55700,59321,59322,59323,59326,59336,61233,61383,48720,49779,57652) AND `brand_id` > 0 [ RunTime:0.001982s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000500s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4884,4803,4994,5108,4971,4996,4995,5010,5061,4563,4450,5013,4909,4907,4986,4714,5434,5223,5183,5501,5467,5418,5433,5443,5444,5628,6112,6134,6031,6266,5597,4549,4560,5844,5156,5908,5918,5932,5284,5426,5977,5971,5986,5998,6002,5883,4857,6054,4478,5273,6128,6143,6156,6185,6210,6394,6578,6629,6576,6628,5399,7139,5200,6685,6830,7165,6836,6837,6849,6850,6851,6852,6853,6855,6856,7422,7044,6050,6661,4552,5643,6966,6967,7575,6921,5631,7483,7137,4706,5368,7857,6058,4926,4905,5554) GROUP BY `name` LIMIT 30 [ RunTime:0.000424s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(37062,37750,38311,39618,49160,50228,55702,55704,55705,55706,55777,61046,61203,63805,63813,63817,63922,37762,49656,40358,44306,52174,52266,52827,57060,33367,34506,37064,38952,39017,39459,40352,41448,33406,33408,33410,33361,35640,42889,53613,58469,39458,33300,39457,42900,42916,33280,58046,33261,33267,33271,33282,33291,33296,35799,37063,38353,38869,38948,41690,41951,41975,42328,42408,42553,42674,42800,42810,42890,43125,43212,43215,43216,43299,43300,43528,43770,43835,43983,44235,45903,46180,47453,47949,51232,51532,52796,53007,53039,53125,53812,58658,33255,33902,36065,39081,41417,41418,42774,44115,44366,44616,56195,56690,57931,58118,62429,42786,45343,45344,45345,33017,33038,33041,33044,33046,41756,41791,42275,42551,42573,42605,42608,42611,43918,56261,46936,59316,38882,47180,47239,43644,43645,43646,43647,43648,43649,52263,43837,43179,65541,51121,43752,43070,50164,50165,45170,45711,45712,35871,41113,41406,41778,41779,41955,42203,42434,42521,42522,42703,42752,42753,44063,44878,44990,44991,45911,45915,46885,46889,46891,47086,47128,49056,49113,49362,49367,49372,50486,50917,50918,50919,50920,50921,50943,50944,50945,50946,50947,50996,50997,50998,50999,51000,51003,51349,51354,51355,51356,51357,51358,51529,52215,52291,52292,52533,52534,52574,52575,52576,52577,52578,52579,52580,52581,52582,52583,52584,52585,52586,52587,52588,52589,52590,52634,52638,52677,52751,52753,52754,52755,52756,53142,53191,53280,53281,53377,53422,53423,53644,53873,54288,54770,54882,54934,54936,55028,55060,55071,55074,55292,55388,55390,55391,55393,55394,55395,55396,55397,55398,55399,55400,55401,55402,55635,55636,55637,55638,55639,55640,55641,56205,56475,56480,56493,56494,56495,56496,56514,56515,56672,56731,56773,56774,56775,56776,56777,56778,56779,56780,56781,56784,56785,56786,56789,56790,56791,56792,57075,57078,57079,57081,57082,57083,57086,57136,57264,57265,57266,57339,57615,57686,57687,57713,57875,58412,58413,58414,58415,58416,58417,58517,58518,58521,58524,58525,58526,58528,58529,58530,58531,58532,58533,58534,58535,58536,58660,58661,58718,58720,58722,58723,58724,58725,58726,58727,58960,58961,58962,58963,59007,59196,59222,59223,59224,59225,59247,59303,59304,59639,59640,60064,60161,63947,66496,66497,66513,66603,66605,66651,66828,33136,33140,33142,35805,35811,36166,37180,40140,44102,52942,52944,52945,52948,52961,52966,52969,52974,52975,53629,53655,53897,53898,53900,53914,53917,53918,53919,53920,56685,35819,48020,51837,52095,52096,52097,52098,52136,52681,39089,39768,41315,41740,43688,44411,47392,48017,52678,52679,56693,56783,58072,41179,41180,49874,33899,33900,46238,46350,46351,47156,49371,33901,41316,45723,51157,41834,41835,45913,47348,49360,49361,52050,52664,52665,52666,52667,56733,40258,46573,46574,46609,51752,52660,55392,56234,56659,56673,56674,57491,57492,57493,57666,35867,42013,47155,49012,52752,52757,55293,56476,52074,52076,52078,52079,55687,57730,40395,45759,43982,55284,55286,56040,33126,45335,52477,37752,37753,38310,39456,39617,54005,54031,54034,54036,54037,61202,38865,39557,42947,43250,47407,38855,42352,45350,45351,45764,46572,46594,46748,47413,49366,49877,50364,51541,52559,52560,52680,52748,53144,53145,54391,56757,57076,57077,57080,59014,65781,68292,38859,41129,45914,45917,46890,46892,49112,49365,51910,52682,52758,53874,55072,55073,55389,56238,56787,56788,57084,57085,57207,58783,39517,40825,41130,43446,47320,47850,62878,41131,42324,44050,46477,42895,47588,49111,57424,57561,57667,58368,51978,52541,55686,55700,59321,59322,59323,59326,59336,61233,61383,48720,49779,57652) [ RunTime:0.000442s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000417s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (37062,37750,38311,39618,49160,50228,55702,55704,55705,55706,55777,61046,61203,63805,63813,63817,63922,37762,49656,40358,44306,52174,52266,52827,57060,33367,34506,37064,38952,39017,39459,40352,41448,33406,33408,33410,33361,35640,42889,53613,58469,39458,33300,39457,42900,42916,33280,58046,33261,33267,33271,33282,33291,33296,35799,37063,38353,38869,38948,41690,41951,41975,42328,42408,42553,42674,42800,42810,42890,43125,43212,43215,43216,43299,43300,43528,43770,43835,43983,44235,45903,46180,47453,47949,51232,51532,52796,53007,53039,53125,53812,58658,33255,33902,36065,39081,41417,41418,42774,44115,44366,44616,56195,56690,57931,58118,62429,42786,45343,45344,45345,33017,33038,33041,33044,33046,41756,41791,42275,42551,42573,42605,42608,42611,43918,56261,46936,59316,38882,47180,47239,43644,43645,43646,43647,43648,43649,52263,43837,43179,65541,51121,43752,43070,50164,50165,45170,45711,45712,35871,41113,41406,41778,41779,41955,42203,42434,42521,42522,42703,42752,42753,44063,44878,44990,44991,45911,45915,46885,46889,46891,47086,47128,49056,49113,49362,49367,49372,50486,50917,50918,50919,50920,50921,50943,50944,50945,50946,50947,50996,50997,50998,50999,51000,51003,51349,51354,51355,51356,51357,51358,51529,52215,52291,52292,52533,52534,52574,52575,52576,52577,52578,52579,52580,52581,52582,52583,52584,52585,52586,52587,52588,52589,52590,52634,52638,52677,52751,52753,52754,52755,52756,53142,53191,53280,53281,53377,53422,53423,53644,53873,54288,54770,54882,54934,54936,55028,55060,55071,55074,55292,55388,55390,55391,55393,55394,55395,55396,55397,55398,55399,55400,55401,55402,55635,55636,55637,55638,55639,55640,55641,56205,56475,56480,56493,56494,56495,56496,56514,56515,56672,56731,56773,56774,56775,56776,56777,56778,56779,56780,56781,56784,56785,56786,56789,56790,56791,56792,57075,57078,57079,57081,57082,57083,57086,57136,57264,57265,57266,57339,57615,57686,57687,57713,57875,58412,58413,58414,58415,58416,58417,58517,58518,58521,58524,58525,58526,58528,58529,58530,58531,58532,58533,58534,58535,58536,58660,58661,58718,58720,58722,58723,58724,58725,58726,58727,58960,58961,58962,58963,59007,59196,59222,59223,59224,59225,59247,59303,59304,59639,59640,60064,60161,63947,66496,66497,66513,66603,66605,66651,66828,33136,33140,33142,35805,35811,36166,37180,40140,44102,52942,52944,52945,52948,52961,52966,52969,52974,52975,53629,53655,53897,53898,53900,53914,53917,53918,53919,53920,56685,35819,48020,51837,52095,52096,52097,52098,52136,52681,39089,39768,41315,41740,43688,44411,47392,48017,52678,52679,56693,56783,58072,41179,41180,49874,33899,33900,46238,46350,46351,47156,49371,33901,41316,45723,51157,41834,41835,45913,47348,49360,49361,52050,52664,52665,52666,52667,56733,40258,46573,46574,46609,51752,52660,55392,56234,56659,56673,56674,57491,57492,57493,57666,35867,42013,47155,49012,52752,52757,55293,56476,52074,52076,52078,52079,55687,57730,40395,45759,43982,55284,55286,56040,33126,45335,52477,37752,37753,38310,39456,39617,54005,54031,54034,54036,54037,61202,38865,39557,42947,43250,47407,38855,42352,45350,45351,45764,46572,46594,46748,47413,49366,49877,50364,51541,52559,52560,52680,52748,53144,53145,54391,56757,57076,57077,57080,59014,65781,68292,38859,41129,45914,45917,46890,46892,49112,49365,51910,52682,52758,53874,55072,55073,55389,56238,56787,56788,57084,57085,57207,58783,39517,40825,41130,43446,47320,47850,62878,41131,42324,44050,46477,42895,47588,49111,57424,57561,57667,58368,51978,52541,55686,55700,59321,59322,59323,59326,59336,61233,61383,48720,49779,57652) AND `attr_value` <> '' [ RunTime:0.002027s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000494s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000182s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (37062,37750,38311,39618,49160,50228,55702,55704,55705,55706,55777,61046,61203,63805,63813,63817,63922,37762,49656,40358,44306,52174,52266,52827,57060,33367,34506,37064,38952,39017,39459,40352,41448,33406,33408,33410,33361,35640,42889,53613,58469,39458,33300,39457,42900,42916,33280,58046,33261,33267,33271,33282,33291,33296,35799,37063,38353,38869,38948,41690,41951,41975,42328,42408,42553,42674,42800,42810,42890,43125,43212,43215,43216,43299,43300,43528,43770,43835,43983,44235,45903,46180,47453,47949,51232,51532,52796,53007,53039,53125,53812,58658,33255,33902,36065,39081,41417,41418,42774,44115,44366,44616,56195,56690,57931,58118,62429,42786,45343,45344,45345,33017,33038,33041,33044,33046,41756,41791,42275,42551,42573,42605,42608,42611,43918,56261,46936,59316,38882,47180,47239,43644,43645,43646,43647,43648,43649,52263,43837,43179,65541,51121,43752,43070,50164,50165,45170,45711,45712,35871,41113,41406,41778,41779,41955,42203,42434,42521,42522,42703,42752,42753,44063,44878,44990,44991,45911,45915,46885,46889,46891,47086,47128,49056,49113,49362,49367,49372,50486,50917,50918,50919,50920,50921,50943,50944,50945,50946,50947,50996,50997,50998,50999,51000,51003,51349,51354,51355,51356,51357,51358,51529,52215,52291,52292,52533,52534,52574,52575,52576,52577,52578,52579,52580,52581,52582,52583,52584,52585,52586,52587,52588,52589,52590,52634,52638,52677,52751,52753,52754,52755,52756,53142,53191,53280,53281,53377,53422,53423,53644,53873,54288,54770,54882,54934,54936,55028,55060,55071,55074,55292,55388,55390,55391,55393,55394,55395,55396,55397,55398,55399,55400,55401,55402,55635,55636,55637,55638,55639,55640,55641,56205,56475,56480,56493,56494,56495,56496,56514,56515,56672,56731,56773,56774,56775,56776,56777,56778,56779,56780,56781,56784,56785,56786,56789,56790,56791,56792,57075,57078,57079,57081,57082,57083,57086,57136,57264,57265,57266,57339,57615,57686,57687,57713,57875,58412,58413,58414,58415,58416,58417,58517,58518,58521,58524,58525,58526,58528,58529,58530,58531,58532,58533,58534,58535,58536,58660,58661,58718,58720,58722,58723,58724,58725,58726,58727,58960,58961,58962,58963,59007,59196,59222,59223,59224,59225,59247,59303,59304,59639,59640,60064,60161,63947,66496,66497,66513,66603,66605,66651,66828,33136,33140,33142,35805,35811,36166,37180,40140,44102,52942,52944,52945,52948,52961,52966,52969,52974,52975,53629,53655,53897,53898,53900,53914,53917,53918,53919,53920,56685,35819,48020,51837,52095,52096,52097,52098,52136,52681,39089,39768,41315,41740,43688,44411,47392,48017,52678,52679,56693,56783,58072,41179,41180,49874,33899,33900,46238,46350,46351,47156,49371,33901,41316,45723,51157,41834,41835,45913,47348,49360,49361,52050,52664,52665,52666,52667,56733,40258,46573,46574,46609,51752,52660,55392,56234,56659,56673,56674,57491,57492,57493,57666,35867,42013,47155,49012,52752,52757,55293,56476,52074,52076,52078,52079,55687,57730,40395,45759,43982,55284,55286,56040,33126,45335,52477,37752,37753,38310,39456,39617,54005,54031,54034,54036,54037,61202,38865,39557,42947,43250,47407,38855,42352,45350,45351,45764,46572,46594,46748,47413,49366,49877,50364,51541,52559,52560,52680,52748,53144,53145,54391,56757,57076,57077,57080,59014,65781,68292,38859,41129,45914,45917,46890,46892,49112,49365,51910,52682,52758,53874,55072,55073,55389,56238,56787,56788,57084,57085,57207,58783,39517,40825,41130,43446,47320,47850,62878,41131,42324,44050,46477,42895,47588,49111,57424,57561,57667,58368,51978,52541,55686,55700,59321,59322,59323,59326,59336,61233,61383,48720,49779,57652) ORDER BY `sort` ASC LIMIT 540,20 [ RunTime:0.005022s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.000438s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.000450s ]
SELECT * FROM `tp_ad` WHERE ( pid=101 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000183s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000137s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000192s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000169s ]
SELECT * FROM `tp_ad` WHERE ( pid=102 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000193s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000137s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000186s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
SELECT * FROM `tp_ad` WHERE ( pid=103 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000188s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000159s ]
SELECT * FROM `tp_ad` WHERE ( pid=104 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000176s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000142s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000178s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000165s ]
SELECT * FROM `tp_ad` WHERE ( pid=105 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000158s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000178s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000162s ]
SELECT * FROM `tp_ad` WHERE ( pid=106 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000171s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000134s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000153s ]
SELECT * FROM `tp_ad` WHERE ( pid=107 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000190s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000148s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000165s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000164s ]
SELECT * FROM `tp_ad` WHERE ( pid=108 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000189s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000139s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000165s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000159s ]
SELECT * FROM `tp_ad` WHERE ( pid=109 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000185s ]
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 < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000165s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000158s ]
SELECT * FROM `tp_ad` WHERE ( pid=110 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000190s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000140s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000167s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000166s ]
SELECT * FROM `tp_ad` WHERE ( pid=111 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000169s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000152s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000176s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000168s ]
SELECT * FROM `tp_ad` WHERE ( pid=112 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) 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.000135s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000182s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000150s ]
SELECT * FROM `tp_ad` WHERE ( pid=113 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000173s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000138s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000165s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000157s ]
SELECT * FROM `tp_ad` WHERE ( pid=114 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000189s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000154s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000167s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000164s ]
SELECT * FROM `tp_ad` WHERE ( pid=115 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 5 [ RunTime:0.000171s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000137s ]
SELECT * FROM `tp_ad` WHERE ( pid=51 and enabled = 1 and start_time < 1765533600 and end_time > 1765533600 ) ORDER BY `orderby` DESC LIMIT 1 [ RunTime:0.000189s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000163s ]
select goods_id,goods_sn,goods_name,shop_price,zs_price from `tp_goods` where is_hot=1 and is_on_sale = 1 limit 5 [ RunTime:0.000184s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.000156s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.000147s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.000156s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.000145s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31136 LIMIT 1 [ RunTime:0.000157s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46572 LIMIT 1 [ RunTime:0.000282s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33261 LIMIT 1 [ RunTime:0.000223s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46573 LIMIT 1 [ RunTime:0.000229s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46574 LIMIT 1 [ RunTime:0.000233s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47086 LIMIT 1 [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 52974 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 52975 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43250 LIMIT 1 [ RunTime:0.000679s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54770 LIMIT 1 [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33267 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57075 LIMIT 1 [ RunTime:0.000229s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 47348 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50164 LIMIT 1 [ RunTime:0.000220s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55028 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55284 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57076 LIMIT 1 [ RunTime:0.000227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 65781 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50165 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54005 LIMIT 1 [ RunTime:0.000232s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57077 LIMIT 1 [ RunTime:0.000230s ]
select * from `tp_slogan` [ RunTime:0.000144s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.000169s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.000175s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.000165s ]