SHOW FULL COLUMNS FROM `tp_users` [ RunTime:0.010006s ]
SELECT * FROM `tp_users` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.005647s ]
SHOW FULL COLUMNS FROM `tp_user_message` [ RunTime:0.005015s ]
SELECT COUNT(*) AS think_count FROM `tp_user_message` WHERE `user_id` IS NULL AND `is_see` = 0 AND `deleted` = 0 [ RunTime:0.003545s ]
SHOW FULL COLUMNS FROM `tp_wx_user` [ RunTime:0.018288s ]
SELECT `qr` FROM `tp_wx_user` LIMIT 1 [ RunTime:0.004250s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.008572s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1235 LIMIT 1 [ RunTime:0.004510s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.004874s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1235 [ RunTime:0.004726s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.005239s ]
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.015547s ]
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.021618s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.014020s ]
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.005510s ]
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.004432s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.004011s ]
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.005513s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.004600s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.004508s ]
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 220,20 [ RunTime:0.008035s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.010283s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (43097,33882,37466,41562,41818,43098,44378,44890,50522,33883,37467,41563,41819,44379,50523,33884,37468,41820,44380,50524) [ RunTime:0.010456s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.003172s ]
SHOW FULL COLUMNS FROM `tp_ad_position` [ RunTime:0.006537s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002586s ]
SHOW FULL COLUMNS FROM `tp_ad` [ RunTime:0.004769s ]
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.001485s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003869s ]
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.006786s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004696s ]
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.003696s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002507s ]
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.001935s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004838s ]
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.006581s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002923s ]
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.002875s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002970s ]
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.003022s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001983s ]
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.002814s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002399s ]
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.002963s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.004172s ]
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.004837s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002254s ]
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.006721s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002963s ]
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.001328s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001783s ]
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.001523s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000923s ]
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.003289s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002816s ]
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.006177s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.003740s ]
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.001451s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001539s ]
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.001450s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001013s ]
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.001232s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000535s ]
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.003481s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001192s ]
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.000998s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001145s ]
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.001760s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001198s ]
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.000970s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001229s ]
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.001719s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002104s ]
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.001093s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001194s ]
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.001402s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001312s ]
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.001078s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001039s ]
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.002259s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.001861s ]
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.001126s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000497s ]
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.001058s ]
SELECT `position_id`,`position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.002292s ]
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.001446s ]
SELECT * FROM `tp_navigation` where is_show = 1 and position = 'top' ORDER BY `sort` DESC [ RunTime:0.001040s ]
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.001794s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.001975s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.002217s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.001095s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.000877s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31136 LIMIT 1 [ RunTime:0.001453s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43097 LIMIT 1 [ RunTime:0.001266s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33882 LIMIT 1 [ RunTime:0.002396s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37466 LIMIT 1 [ RunTime:0.001280s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41562 LIMIT 1 [ RunTime:0.001540s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41818 LIMIT 1 [ RunTime:0.001025s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43098 LIMIT 1 [ RunTime:0.001198s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44378 LIMIT 1 [ RunTime:0.002021s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44890 LIMIT 1 [ RunTime:0.001234s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50522 LIMIT 1 [ RunTime:0.001353s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33883 LIMIT 1 [ RunTime:0.001230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37467 LIMIT 1 [ RunTime:0.001797s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41563 LIMIT 1 [ RunTime:0.001860s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41819 LIMIT 1 [ RunTime:0.001146s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44379 LIMIT 1 [ RunTime:0.002771s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50523 LIMIT 1 [ RunTime:0.003136s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33884 LIMIT 1 [ RunTime:0.001994s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 37468 LIMIT 1 [ RunTime:0.003203s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41820 LIMIT 1 [ RunTime:0.005489s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44380 LIMIT 1 [ RunTime:0.010246s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50524 LIMIT 1 [ RunTime:0.004920s ]
select * from `tp_slogan` [ RunTime:0.003503s ]
select * from `tp_friend_link` where is_show=1 [ RunTime:0.006973s ]
SELECT * FROM `tp_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.006068s ]
select * from `tp_article` where cat_id = 5 and is_open=1 [ RunTime:0.005752s ]