SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.000983s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000404s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.000579s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.000238s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.000790s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.000225s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000671s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1235 LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000585s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1235 [ RunTime:0.000246s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001037s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (33349,33766,33767,33798,33799,33801,33802,33803,33804,33805,35463,37711,38980,47902,57256,52774,33350,33357,33359,33749,33753,33764,33765,33768,33781,33812,35287,35290,35473,35475,35478,35485,35486,35487,35488,35490,35494,35496,35498,35501,35504,35506,36149,36921,36922,36923,36924,36926,36932,36933,36934,36935,36942,36943,36944,36946,36947,36948,36949,39102,45674,33722,33723,35282,35552,35553,33861,33863,33707,33735,33742,33864,35278,35279,35280,37295,44378,54484,35276,35277,35511,41116,55543,56314,33779,35251,35252,35253,35503,48106,48107,49288,49289,49290,50230,55200,55448,55541,55544,58120,59282,65623,35248,35249,35250,35543,35544,35547,35549,35550,35551,36782,33712,33869,33870,39531,33646,33872,35554,35577,35578,35582,37203,47471,51843,56995,33637,33638,35584,35586,36467,38634,44281,48749,48865,52713,53364,58054,58119,33574,33610,33612,33618,33629,35591,41252,41496,43088,46929,51212,51214,57698,57712,58117,58139,33553,33556,33563,41959,41960,41961,43031,49421,32951,32955,32960,32962,32969,32976,32980,32983,43097,43098,49423,53365,53366,32064,39564,39565,43094,43333,43640,43641,44282,51301,51303,33873,33158,33175,33179,33182,33875,33876,33877,33878,33879,33880,43095,43096,43924,51771,54645,33882,33883,33884,41300,33886,35732,47326,56087,32050,32051,32052,32053,35238,35239,35240,35241,35242,33011,33030,33033,33064,43093,32061,32989,32996,33001,33003,33005,33551,33887,35230,35231,35609,35617,35618,33578,33580,33583,35229,35601,35602,35606,35610,38549,39179,39490,41474,42767,43799,44254,44255,44372,44805,45727,47325,47554,54543,54865,55775,57456,58192,58193,58224,58225,63843,63844,35221,35336,41404,54592,46927,54853,54854,54872,55006,55107,55108,55109,55113,55116,55119,55120,55133,56255,56400,57901,58790,58800,56401,58799,33231,35691,35694,55441,55442,55445,65538,33209,33215,52670,55438,55439,55440,55446,55447,33178,33196,33200,35199,35200,35201,35703,35709,37141,45216,51769,52510,33162,35713,35716,35717,35718,59110,35197,35726,38439,38440,38441,38442,38444,38447,38448,38449,38450,38471,38472,38473,38474,43917,35194,35195,35735,35188,35189,35736,35739,35741,35744,35746,36849,36850,38960,41497,41746,41754,41755,41761,41763,41764,41772,41801,41804,41807,41810,41811,41815,41817,41818,41819,41820,41821,41871,41874,41876,41877,41878,41879,41880,41882,41883,41884,41886,41887,41888,41889,41894,41895,41897,41898,41899,41900,41901,41902,41903,41904,41906,41907,41908,41909,41910,41911,41912,41913,41914,41916,41918,41919,41920,41921,41924,41925,41926,41927,41928,41929,41930,41931,41932,41933,41934,41935,41936,41941,41942,41943,41944,41945,41946,41947,41948,41949,41950,42642,43642,43923,45435,45436,45437,45438,46216,51842,53457,54095,54096,54097,54098,56080,56081,57520,57704,57926,58070,67865,33893,33894,35750,41953,55588,55589,55590,55595,55596,55597,55598,55599,55600,55601,55602,35187,33892,35759,35760,35761,33790,33791,33792,33793,35338,35339,35340,35343,35347,35348,35351,37811,37812,41537,41540,41541,42922,50519,50522,50523,50524,50526,50539,54390,57837,58748,33795,33796,35364,35366,35367,35368,41565,41566,41567,50556,33969,36136,36137,44519,44520,44521,44525,44526,44527,44890,36603,37465,37466,37467,37468,37469,37471,37472,37473,37474,37475,37476,37477,37478,37479,37480,39404,41553,41554,41555,42016,44238,49617,50515,50518,50567,55744,41495,41954,41956,41957,41958,41969,41971,41972,44280,43894,43895,41544,41545,44379,44380,44381,44382,44383,44384,44385,45675,50512,50513,50514,50568,50569,50570,50571,50572,50577,50578,50579,50591,50592,50593,50594,50595,54514,58785,41556,41557,41558,41559,41560,41561,41562,41563,50555,44365) [ RunTime:0.006091s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (33349,33766,33767,33798,33799,33801,33802,33803,33804,33805,35463,37711,38980,47902,57256,52774,33350,33357,33359,33749,33753,33764,33765,33768,33781,33812,35287,35290,35473,35475,35478,35485,35486,35487,35488,35490,35494,35496,35498,35501,35504,35506,36149,36921,36922,36923,36924,36926,36932,36933,36934,36935,36942,36943,36944,36946,36947,36948,36949,39102,45674,33722,33723,35282,35552,35553,33861,33863,33707,33735,33742,33864,35278,35279,35280,37295,44378,54484,35276,35277,35511,41116,55543,56314,33779,35251,35252,35253,35503,48106,48107,49288,49289,49290,50230,55200,55448,55541,55544,58120,59282,65623,35248,35249,35250,35543,35544,35547,35549,35550,35551,36782,33712,33869,33870,39531,33646,33872,35554,35577,35578,35582,37203,47471,51843,56995,33637,33638,35584,35586,36467,38634,44281,48749,48865,52713,53364,58054,58119,33574,33610,33612,33618,33629,35591,41252,41496,43088,46929,51212,51214,57698,57712,58117,58139,33553,33556,33563,41959,41960,41961,43031,49421,32951,32955,32960,32962,32969,32976,32980,32983,43097,43098,49423,53365,53366,32064,39564,39565,43094,43333,43640,43641,44282,51301,51303,33873,33158,33175,33179,33182,33875,33876,33877,33878,33879,33880,43095,43096,43924,51771,54645,33882,33883,33884,41300,33886,35732,47326,56087,32050,32051,32052,32053,35238,35239,35240,35241,35242,33011,33030,33033,33064,43093,32061,32989,32996,33001,33003,33005,33551,33887,35230,35231,35609,35617,35618,33578,33580,33583,35229,35601,35602,35606,35610,38549,39179,39490,41474,42767,43799,44254,44255,44372,44805,45727,47325,47554,54543,54865,55775,57456,58192,58193,58224,58225,63843,63844,35221,35336,41404,54592,46927,54853,54854,54872,55006,55107,55108,55109,55113,55116,55119,55120,55133,56255,56400,57901,58790,58800,56401,58799,33231,35691,35694,55441,55442,55445,65538,33209,33215,52670,55438,55439,55440,55446,55447,33178,33196,33200,35199,35200,35201,35703,35709,37141,45216,51769,52510,33162,35713,35716,35717,35718,59110,35197,35726,38439,38440,38441,38442,38444,38447,38448,38449,38450,38471,38472,38473,38474,43917,35194,35195,35735,35188,35189,35736,35739,35741,35744,35746,36849,36850,38960,41497,41746,41754,41755,41761,41763,41764,41772,41801,41804,41807,41810,41811,41815,41817,41818,41819,41820,41821,41871,41874,41876,41877,41878,41879,41880,41882,41883,41884,41886,41887,41888,41889,41894,41895,41897,41898,41899,41900,41901,41902,41903,41904,41906,41907,41908,41909,41910,41911,41912,41913,41914,41916,41918,41919,41920,41921,41924,41925,41926,41927,41928,41929,41930,41931,41932,41933,41934,41935,41936,41941,41942,41943,41944,41945,41946,41947,41948,41949,41950,42642,43642,43923,45435,45436,45437,45438,46216,51842,53457,54095,54096,54097,54098,56080,56081,57520,57704,57926,58070,67865,33893,33894,35750,41953,55588,55589,55590,55595,55596,55597,55598,55599,55600,55601,55602,35187,33892,35759,35760,35761,33790,33791,33792,33793,35338,35339,35340,35343,35347,35348,35351,37811,37812,41537,41540,41541,42922,50519,50522,50523,50524,50526,50539,54390,57837,58748,33795,33796,35364,35366,35367,35368,41565,41566,41567,50556,33969,36136,36137,44519,44520,44521,44525,44526,44527,44890,36603,37465,37466,37467,37468,37469,37471,37472,37473,37474,37475,37476,37477,37478,37479,37480,39404,41553,41554,41555,42016,44238,49617,50515,50518,50567,55744,41495,41954,41956,41957,41958,41969,41971,41972,44280,43894,43895,41544,41545,44379,44380,44381,44382,44383,44384,44385,45675,50512,50513,50514,50568,50569,50570,50571,50572,50577,50578,50579,50591,50592,50593,50594,50595,54514,58785,41556,41557,41558,41559,41560,41561,41562,41563,50555,44365) AND `brand_id` > 0 [ RunTime:0.006036s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000718s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4782,4788,4789,4492,4441,4548,4883,4885,4513,4505,4514,4911,5132,4435,4449,5029,4964,4454,4771,4893,5019,5020,4442,4976,5080,4619,5124,4623,4766,4490,5066,5118,5079,5127,5107,4725,5074,5119,5122,5005,4517,4753,5184,5120,5000,5177,5025,4820,5006,4622,5001,5077,4967,4704,5045,5046,5047,5453,5157,5310,5313,5446,4450,5529,5536,4478,5170,5818,5489,6266,5604,6653,6088,6122,6127,4668,6213,6214,5363,6215,6224,6225,6226,6105,5883,5485,5880,4495,7139,6904,5711,5319,5285,6094,6629,7010,6696,7700,4783,7019,7716,4816,6661,5817,4813,7528,5336,5715,5007,6803,4746,5659,7751,4856,7305) GROUP BY `name` LIMIT 30 [ RunTime:0.000723s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(33349,33766,33767,33798,33799,33801,33802,33803,33804,33805,35463,37711,38980,47902,57256,52774,33350,33357,33359,33749,33753,33764,33765,33768,33781,33812,35287,35290,35473,35475,35478,35485,35486,35487,35488,35490,35494,35496,35498,35501,35504,35506,36149,36921,36922,36923,36924,36926,36932,36933,36934,36935,36942,36943,36944,36946,36947,36948,36949,39102,45674,33722,33723,35282,35552,35553,33861,33863,33707,33735,33742,33864,35278,35279,35280,37295,44378,54484,35276,35277,35511,41116,55543,56314,33779,35251,35252,35253,35503,48106,48107,49288,49289,49290,50230,55200,55448,55541,55544,58120,59282,65623,35248,35249,35250,35543,35544,35547,35549,35550,35551,36782,33712,33869,33870,39531,33646,33872,35554,35577,35578,35582,37203,47471,51843,56995,33637,33638,35584,35586,36467,38634,44281,48749,48865,52713,53364,58054,58119,33574,33610,33612,33618,33629,35591,41252,41496,43088,46929,51212,51214,57698,57712,58117,58139,33553,33556,33563,41959,41960,41961,43031,49421,32951,32955,32960,32962,32969,32976,32980,32983,43097,43098,49423,53365,53366,32064,39564,39565,43094,43333,43640,43641,44282,51301,51303,33873,33158,33175,33179,33182,33875,33876,33877,33878,33879,33880,43095,43096,43924,51771,54645,33882,33883,33884,41300,33886,35732,47326,56087,32050,32051,32052,32053,35238,35239,35240,35241,35242,33011,33030,33033,33064,43093,32061,32989,32996,33001,33003,33005,33551,33887,35230,35231,35609,35617,35618,33578,33580,33583,35229,35601,35602,35606,35610,38549,39179,39490,41474,42767,43799,44254,44255,44372,44805,45727,47325,47554,54543,54865,55775,57456,58192,58193,58224,58225,63843,63844,35221,35336,41404,54592,46927,54853,54854,54872,55006,55107,55108,55109,55113,55116,55119,55120,55133,56255,56400,57901,58790,58800,56401,58799,33231,35691,35694,55441,55442,55445,65538,33209,33215,52670,55438,55439,55440,55446,55447,33178,33196,33200,35199,35200,35201,35703,35709,37141,45216,51769,52510,33162,35713,35716,35717,35718,59110,35197,35726,38439,38440,38441,38442,38444,38447,38448,38449,38450,38471,38472,38473,38474,43917,35194,35195,35735,35188,35189,35736,35739,35741,35744,35746,36849,36850,38960,41497,41746,41754,41755,41761,41763,41764,41772,41801,41804,41807,41810,41811,41815,41817,41818,41819,41820,41821,41871,41874,41876,41877,41878,41879,41880,41882,41883,41884,41886,41887,41888,41889,41894,41895,41897,41898,41899,41900,41901,41902,41903,41904,41906,41907,41908,41909,41910,41911,41912,41913,41914,41916,41918,41919,41920,41921,41924,41925,41926,41927,41928,41929,41930,41931,41932,41933,41934,41935,41936,41941,41942,41943,41944,41945,41946,41947,41948,41949,41950,42642,43642,43923,45435,45436,45437,45438,46216,51842,53457,54095,54096,54097,54098,56080,56081,57520,57704,57926,58070,67865,33893,33894,35750,41953,55588,55589,55590,55595,55596,55597,55598,55599,55600,55601,55602,35187,33892,35759,35760,35761,33790,33791,33792,33793,35338,35339,35340,35343,35347,35348,35351,37811,37812,41537,41540,41541,42922,50519,50522,50523,50524,50526,50539,54390,57837,58748,33795,33796,35364,35366,35367,35368,41565,41566,41567,50556,33969,36136,36137,44519,44520,44521,44525,44526,44527,44890,36603,37465,37466,37467,37468,37469,37471,37472,37473,37474,37475,37476,37477,37478,37479,37480,39404,41553,41554,41555,42016,44238,49617,50515,50518,50567,55744,41495,41954,41956,41957,41958,41969,41971,41972,44280,43894,43895,41544,41545,44379,44380,44381,44382,44383,44384,44385,45675,50512,50513,50514,50568,50569,50570,50571,50572,50577,50578,50579,50591,50592,50593,50594,50595,54514,58785,41556,41557,41558,41559,41560,41561,41562,41563,50555,44365) [ RunTime:0.000636s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000593s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (33349,33766,33767,33798,33799,33801,33802,33803,33804,33805,35463,37711,38980,47902,57256,52774,33350,33357,33359,33749,33753,33764,33765,33768,33781,33812,35287,35290,35473,35475,35478,35485,35486,35487,35488,35490,35494,35496,35498,35501,35504,35506,36149,36921,36922,36923,36924,36926,36932,36933,36934,36935,36942,36943,36944,36946,36947,36948,36949,39102,45674,33722,33723,35282,35552,35553,33861,33863,33707,33735,33742,33864,35278,35279,35280,37295,44378,54484,35276,35277,35511,41116,55543,56314,33779,35251,35252,35253,35503,48106,48107,49288,49289,49290,50230,55200,55448,55541,55544,58120,59282,65623,35248,35249,35250,35543,35544,35547,35549,35550,35551,36782,33712,33869,33870,39531,33646,33872,35554,35577,35578,35582,37203,47471,51843,56995,33637,33638,35584,35586,36467,38634,44281,48749,48865,52713,53364,58054,58119,33574,33610,33612,33618,33629,35591,41252,41496,43088,46929,51212,51214,57698,57712,58117,58139,33553,33556,33563,41959,41960,41961,43031,49421,32951,32955,32960,32962,32969,32976,32980,32983,43097,43098,49423,53365,53366,32064,39564,39565,43094,43333,43640,43641,44282,51301,51303,33873,33158,33175,33179,33182,33875,33876,33877,33878,33879,33880,43095,43096,43924,51771,54645,33882,33883,33884,41300,33886,35732,47326,56087,32050,32051,32052,32053,35238,35239,35240,35241,35242,33011,33030,33033,33064,43093,32061,32989,32996,33001,33003,33005,33551,33887,35230,35231,35609,35617,35618,33578,33580,33583,35229,35601,35602,35606,35610,38549,39179,39490,41474,42767,43799,44254,44255,44372,44805,45727,47325,47554,54543,54865,55775,57456,58192,58193,58224,58225,63843,63844,35221,35336,41404,54592,46927,54853,54854,54872,55006,55107,55108,55109,55113,55116,55119,55120,55133,56255,56400,57901,58790,58800,56401,58799,33231,35691,35694,55441,55442,55445,65538,33209,33215,52670,55438,55439,55440,55446,55447,33178,33196,33200,35199,35200,35201,35703,35709,37141,45216,51769,52510,33162,35713,35716,35717,35718,59110,35197,35726,38439,38440,38441,38442,38444,38447,38448,38449,38450,38471,38472,38473,38474,43917,35194,35195,35735,35188,35189,35736,35739,35741,35744,35746,36849,36850,38960,41497,41746,41754,41755,41761,41763,41764,41772,41801,41804,41807,41810,41811,41815,41817,41818,41819,41820,41821,41871,41874,41876,41877,41878,41879,41880,41882,41883,41884,41886,41887,41888,41889,41894,41895,41897,41898,41899,41900,41901,41902,41903,41904,41906,41907,41908,41909,41910,41911,41912,41913,41914,41916,41918,41919,41920,41921,41924,41925,41926,41927,41928,41929,41930,41931,41932,41933,41934,41935,41936,41941,41942,41943,41944,41945,41946,41947,41948,41949,41950,42642,43642,43923,45435,45436,45437,45438,46216,51842,53457,54095,54096,54097,54098,56080,56081,57520,57704,57926,58070,67865,33893,33894,35750,41953,55588,55589,55590,55595,55596,55597,55598,55599,55600,55601,55602,35187,33892,35759,35760,35761,33790,33791,33792,33793,35338,35339,35340,35343,35347,35348,35351,37811,37812,41537,41540,41541,42922,50519,50522,50523,50524,50526,50539,54390,57837,58748,33795,33796,35364,35366,35367,35368,41565,41566,41567,50556,33969,36136,36137,44519,44520,44521,44525,44526,44527,44890,36603,37465,37466,37467,37468,37469,37471,37472,37473,37474,37475,37476,37477,37478,37479,37480,39404,41553,41554,41555,42016,44238,49617,50515,50518,50567,55744,41495,41954,41956,41957,41958,41969,41971,41972,44280,43894,43895,41544,41545,44379,44380,44381,44382,44383,44384,44385,45675,50512,50513,50514,50568,50569,50570,50571,50572,50577,50578,50579,50591,50592,50593,50594,50595,54514,58785,41556,41557,41558,41559,41560,41561,41562,41563,50555,44365) AND `attr_value` <> '' [ RunTime:0.003469s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000696s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000248s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (33349,33766,33767,33798,33799,33801,33802,33803,33804,33805,35463,37711,38980,47902,57256,52774,33350,33357,33359,33749,33753,33764,33765,33768,33781,33812,35287,35290,35473,35475,35478,35485,35486,35487,35488,35490,35494,35496,35498,35501,35504,35506,36149,36921,36922,36923,36924,36926,36932,36933,36934,36935,36942,36943,36944,36946,36947,36948,36949,39102,45674,33722,33723,35282,35552,35553,33861,33863,33707,33735,33742,33864,35278,35279,35280,37295,44378,54484,35276,35277,35511,41116,55543,56314,33779,35251,35252,35253,35503,48106,48107,49288,49289,49290,50230,55200,55448,55541,55544,58120,59282,65623,35248,35249,35250,35543,35544,35547,35549,35550,35551,36782,33712,33869,33870,39531,33646,33872,35554,35577,35578,35582,37203,47471,51843,56995,33637,33638,35584,35586,36467,38634,44281,48749,48865,52713,53364,58054,58119,33574,33610,33612,33618,33629,35591,41252,41496,43088,46929,51212,51214,57698,57712,58117,58139,33553,33556,33563,41959,41960,41961,43031,49421,32951,32955,32960,32962,32969,32976,32980,32983,43097,43098,49423,53365,53366,32064,39564,39565,43094,43333,43640,43641,44282,51301,51303,33873,33158,33175,33179,33182,33875,33876,33877,33878,33879,33880,43095,43096,43924,51771,54645,33882,33883,33884,41300,33886,35732,47326,56087,32050,32051,32052,32053,35238,35239,35240,35241,35242,33011,33030,33033,33064,43093,32061,32989,32996,33001,33003,33005,33551,33887,35230,35231,35609,35617,35618,33578,33580,33583,35229,35601,35602,35606,35610,38549,39179,39490,41474,42767,43799,44254,44255,44372,44805,45727,47325,47554,54543,54865,55775,57456,58192,58193,58224,58225,63843,63844,35221,35336,41404,54592,46927,54853,54854,54872,55006,55107,55108,55109,55113,55116,55119,55120,55133,56255,56400,57901,58790,58800,56401,58799,33231,35691,35694,55441,55442,55445,65538,33209,33215,52670,55438,55439,55440,55446,55447,33178,33196,33200,35199,35200,35201,35703,35709,37141,45216,51769,52510,33162,35713,35716,35717,35718,59110,35197,35726,38439,38440,38441,38442,38444,38447,38448,38449,38450,38471,38472,38473,38474,43917,35194,35195,35735,35188,35189,35736,35739,35741,35744,35746,36849,36850,38960,41497,41746,41754,41755,41761,41763,41764,41772,41801,41804,41807,41810,41811,41815,41817,41818,41819,41820,41821,41871,41874,41876,41877,41878,41879,41880,41882,41883,41884,41886,41887,41888,41889,41894,41895,41897,41898,41899,41900,41901,41902,41903,41904,41906,41907,41908,41909,41910,41911,41912,41913,41914,41916,41918,41919,41920,41921,41924,41925,41926,41927,41928,41929,41930,41931,41932,41933,41934,41935,41936,41941,41942,41943,41944,41945,41946,41947,41948,41949,41950,42642,43642,43923,45435,45436,45437,45438,46216,51842,53457,54095,54096,54097,54098,56080,56081,57520,57704,57926,58070,67865,33893,33894,35750,41953,55588,55589,55590,55595,55596,55597,55598,55599,55600,55601,55602,35187,33892,35759,35760,35761,33790,33791,33792,33793,35338,35339,35340,35343,35347,35348,35351,37811,37812,41537,41540,41541,42922,50519,50522,50523,50524,50526,50539,54390,57837,58748,33795,33796,35364,35366,35367,35368,41565,41566,41567,50556,33969,36136,36137,44519,44520,44521,44525,44526,44527,44890,36603,37465,37466,37467,37468,37469,37471,37472,37473,37474,37475,37476,37477,37478,37479,37480,39404,41553,41554,41555,42016,44238,49617,50515,50518,50567,55744,41495,41954,41956,41957,41958,41969,41971,41972,44280,43894,43895,41544,41545,44379,44380,44381,44382,44383,44384,44385,45675,50512,50513,50514,50568,50569,50570,50571,50572,50577,50578,50579,50591,50592,50593,50594,50595,54514,58785,41556,41557,41558,41559,41560,41561,41562,41563,50555,44365) ORDER BY `sort` ASC LIMIT 200,20 [ RunTime:0.006859s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000870s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (36949,41557,43093,33878,41558,43094,50518,65623,33879,41559,41815,43095,50519,33880,41560,43096,54872,37465,41561,41817) [ RunTime:0.006024s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.005937s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.004273s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005507s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.002104s ]
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.000890s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.007445s ]
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.002726s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000532s ]
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.001209s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000656s ]
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.000588s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000693s ]
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.002113s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000752s ]
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.000526s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004188s ]
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.006352s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.009490s ]
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.011997s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.014379s ]
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.004737s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006702s ]
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.004582s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005611s ]
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.006313s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006953s ]
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.009692s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.009896s ]
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.007758s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005869s ]
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.006177s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.010129s ]
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.006079s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.007494s ]
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.006213s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.008057s ]
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.012090s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.013768s ]
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.006143s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.005693s ]
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.002704s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001449s ]
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.002081s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000478s ]
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.000886s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000777s ]
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.000928s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001286s ]
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.000952s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000755s ]
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.000935s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002644s ]
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.000962s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000778s ]
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.000968s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001221s ]
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.000959s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000782s ]
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.000921s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001035s ]
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.001281s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000989s ]
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.000770s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000901s ]
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.001959s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.000809s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.000790s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.000937s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.002257s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31136 LIMIT 1 [ RunTime:0.000481s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36949 LIMIT 1 [ RunTime:0.001086s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41557 LIMIT 1 [ RunTime:0.001012s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43093 LIMIT 1 [ RunTime:0.002568s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33878 LIMIT 1 [ RunTime:0.001086s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41558 LIMIT 1 [ RunTime:0.000993s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43094 LIMIT 1 [ RunTime:0.001082s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50518 LIMIT 1 [ RunTime:0.001957s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 65623 LIMIT 1 [ RunTime:0.001070s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33879 LIMIT 1 [ RunTime:0.000907s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41559 LIMIT 1 [ RunTime:0.001079s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41815 LIMIT 1 [ RunTime:0.001513s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43095 LIMIT 1 [ RunTime:0.001067s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50519 LIMIT 1 [ RunTime:0.000928s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33880 LIMIT 1 [ RunTime:0.001106s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41560 LIMIT 1 [ RunTime:0.002169s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43096 LIMIT 1 [ RunTime:0.001077s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54872 LIMIT 1 [ RunTime:0.000923s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37465 LIMIT 1 [ RunTime:0.001091s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41561 LIMIT 1 [ RunTime:0.001275s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41817 LIMIT 1 [ RunTime:0.001096s ]
select * from `tp_slogan` [ RunTime:0.000834s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.000949s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.002023s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.000853s ]