SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.000936s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000357s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.000562s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.000237s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.002415s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.001101s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.001649s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1235 LIMIT 1 [ RunTime:0.002534s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.001582s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1235 [ RunTime:0.001076s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.002013s ]
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.009371s ]
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.006814s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.001651s ]
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.003600s ]
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.001591s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.001411s ]
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.004502s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.007707s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.001109s ]
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 120,20 [ RunTime:0.008137s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.001921s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (54592,41537,39490,55107,36932,38980,41540,55108,33349,33861,36933,41541,43333,54853,55109,33350,36934,54854,57926,33863) [ RunTime:0.002748s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.001255s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.001125s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000913s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.001111s ]
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.000627s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000725s ]
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.001317s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.009933s ]
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.001551s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001583s ]
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.001475s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001079s ]
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.001186s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003345s ]
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.001645s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001151s ]
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.001164s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001414s ]
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.001289s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001475s ]
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.001270s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002884s ]
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.004003s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001439s ]
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.002241s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001704s ]
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.001135s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001186s ]
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.001302s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002930s ]
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.001107s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001629s ]
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.001486s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001552s ]
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.001372s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.006357s ]
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.002064s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002624s ]
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.001618s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001331s ]
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.001628s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002665s ]
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.001415s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001352s ]
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.001368s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000967s ]
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.000786s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000759s ]
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.000877s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000747s ]
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.000869s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000820s ]
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.000812s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000808s ]
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.000805s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000765s ]
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.000863s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000676s ]
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.000747s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000857s ]
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.001019s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001041s ]
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.000902s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.000894s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.000864s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.000980s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.000848s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.000847s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31136 LIMIT 1 [ RunTime:0.000825s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54592 LIMIT 1 [ RunTime:0.001089s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41537 LIMIT 1 [ RunTime:0.000910s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 39490 LIMIT 1 [ RunTime:0.000942s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55107 LIMIT 1 [ RunTime:0.000909s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36932 LIMIT 1 [ RunTime:0.004346s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 38980 LIMIT 1 [ RunTime:0.000344s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41540 LIMIT 1 [ RunTime:0.000409s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55108 LIMIT 1 [ RunTime:0.000357s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33349 LIMIT 1 [ RunTime:0.000690s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33861 LIMIT 1 [ RunTime:0.000362s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36933 LIMIT 1 [ RunTime:0.000344s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41541 LIMIT 1 [ RunTime:0.000338s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43333 LIMIT 1 [ RunTime:0.000346s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54853 LIMIT 1 [ RunTime:0.000349s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55109 LIMIT 1 [ RunTime:0.000330s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33350 LIMIT 1 [ RunTime:0.000347s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36934 LIMIT 1 [ RunTime:0.000338s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 54854 LIMIT 1 [ RunTime:0.000363s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57926 LIMIT 1 [ RunTime:0.000356s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33863 LIMIT 1 [ RunTime:0.000375s ]
select * from `tp_slogan` [ RunTime:0.000240s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.000201s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.000269s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.000393s ]