SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001153s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 41110 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 41110 [ RunTime:0.002462s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.000925s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '号志灯' AND `switch` = 1 LIMIT 1 [ RunTime:0.001476s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001212s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('号','志','灯') AND `switch` = 1 [ RunTime:0.000467s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (2702,2843,3608,4659,6621,6775,9064,9235,10554,11074,11194,12527,13437,14026,14324,14867,15149,15725,16646,18372,18928,18929,20999,25016,25812,26334,31563,31662,33074,33494,33732,35412,35562,35899,36077,36093,36428,37274,38613,39863,40923,41050,41051,41052,41053,41054,41055,41056,41057,41058,41059,41060,41061,41062,41063,41064,41065,41066,41067,41068,41069,41070,41071,41072,41073,41074,41075,41076,41077,41078,41079,41080,41081,41082,41083,41084,41085,41086,41087,41088,41089,41090,41091,41092,41093,41094,41095,41096,41097,41098,41099,41100,41101,41102,41103,41104,41105,41106,41107,41108,41109,41110,41111,42428,43612,44707,45213,47169,48620,52003,52237,52792,52794,54003,54055,54306,55027,55918,56936,58801,62603,64105,64325,64788,65831,65882,65893,66213,66940,66973,67403,69156,69851,70882,71121,71498,72052,73188,77737,78868,79083,81874,82060,82328,84517,84879,85409,85602,88258,88856,89073,89103,89540,93658,94952,95439,95765,96455,98084,104838,105448,106536,106681,106821,111810,111811,112973,113754,117076,117960,119379,119599,120376,121356,123056,124410,124971,126339,128359,132019,132134,132777,132995,133296,134242,134243,134244,136476,137027,138011,139314,140198,142062,142682,142817,143533,143777,145024,145161,148309,148448,149559,149864,149883,152634,152932,153608,153874,153890,156223,159345,159346,159457,160088,162525,164088,165359,166146,166147,166951,169292,169293,169373,170099,171652,171851,173424,176134,176772,176895,178023,178764,181150,182254,183397,184241,184967,187299,187879,189304,192188,196489,197306,197629,198851,199294,199628,199634,199714,200801,202162,202991,203304,203507,204103,204585,206163,207991,208079,210425,210708,210728,211220,213485,214053,215950,217664,218062,218328,218329,218330,219661,219761,223218,223684,226797,227677,227906,228006,229247,229670,230893,230974,231335,232806,232807,232808,237745,238027,238826,241505,242923,244084,245274,246035,246379,247627,249187,251567,254061,254279,255280,258063,258953,259710,260615,2369,4733,7124,7787,7911,10574,11060,14010,14788,15793,16354,17812,17841,18371,18454,25950,27795,29338,32028,33702,33944,36073,37521,37715,38531,38532,38533,38534,38535,42343,42424,44561,44638,47554,49280,53490,53840,53963,53974,55366,55712,57215,59250,59251,59531,60276,62516,68784,69833,70750,72676,72719,74490,74984,75733,77993,78091,78553,78587,79076,79861,80282,80518,82371,83319,83320,83556,85885,86002,86003,86209,88554,93398,95766,97910,99005,101455,101516,101535,101897,102543,106201,107608,108354,110246,111977,112977,115591,118813,119182,119236,120560,122005,126514,126726,126928,130355,130356,130357,131541,133069,133079,134181,134944,135814,137655,139720,139723,139735,141904,142027,142028,142091,145582,147268,147320,148425,149051,149136,150234,150779,150807,150998,152680,152681,153323,153731,153777,154439,156957,157433,158007,158669,158766,161622,161677,163134,163358,164062,164381,164382,165083,165949,167677,169010,172139,172400,175427,178002,178079,179596,180581,181205,181206,181217,181218,183423,183679,184048,184534,186285,186528,186572,186573,188412,189867,190785,191414,192838,196592,199366,199673,202133,204528,206469,206500,207501,207524,208877,211492,212735,216471,216472,217031,217229,219312,223024,224852,225147,227666,228675,229783,230081,230917,239430,241158,241172,242678,245027,246392,247585,248077,248552,250530,252026,253673,254592,254698,258680,258701,689,1351,1352,2120,2571,2661,3914,5191,5192,5336,6943,7739,8093,8101,10024,13517,13574,13613,13726,13977,14157,15113,15668,16125,16443,17450,17454,17663,19707,20441,20743,21345,22589,24220,24221,24399,28308,28912,30017,30259,33686,34565,35245,35476,36185,36186,36187,36901,37081,38725,39567,40208,40568,42979,43382,44315,44783,47362,47601,47702,51065,54388,57400,58118,58986,59027,59789,60155,61005,62510,62746,65061,66105,67194,67688,68187,68951,70539,70933,71816,72968,72971,73315,74138,74709,76048,76062,78504,79173,79237,79520,80048,81749,83470,84374,84701,84837,85220,85368,86465,87357,87708,89558,89695,90465,90785,92140,92244,93019,98533,99306,99885,100097,101190,101667,102870,102915,104541,104556,104586,104587,104588,105160,107334,108342,108863,108937,109491,109897,109936,111181,112604,115205,115451,115499,115631,115667,116001,116199,116620,116984,117461,118249,118425,119088,120118,120247,120999,121753,122295,124147,124347,124451,125945,125990,127048,127939,128413,129206,129377,129605,131371,131464,131658,131980,132070,132211,132931,133445,133451,134401,134613,135891,137360,137569,139317,140036,140114,140482,140754,140920,141308,141416,143162,143216,143246,143247,143643,144084,144430,144607,144752,147503,147712,148949,150354,150845,152030,152661,153161,154163,155619,157117,157354,157825,158092,158366,158655,159473,160785,162090,162446,164312,164469,164573,164625,166508,167504,167642,167656,169261,170052,170313,170522,170772,171037,171587,172635,174767,174807,175187,176331,177445,179020,179078,179884,179973,181535,183014,183111,186167,186402,186403,186427,186507,186565,186709,189097,189422,190895,191150,191753,192010,194268,194330,194970,195032,195129,196547,197472,199852,201638,204186,204209,204210,204734,205287,206236,208047,208268,208491,208548,210021,210022,210023,210024,210221,210354,211077,211790,212234,212336,212490,213091,213339,214092,214126,214156,214978,215509,215720,216529,217889,218070,218456,220074,221409,221436,222610,223168,223920,223959,224878,225078,225203,225349,229143,229144,229145,229146,229147,229148,229149,229150,229151,229152,229153,229154,229155,229156,229157,229158,229159,229160,229161,229162,229163,229164,229165,229166,229167,229168,229169,229170,229171,229172,230972,232792,233025,233802,234291,235262,236640,236643,236648,237544,238273,239252,240306,241142,241948,242880,243778,244423,244553,245154,248930,248931,249224,249225,249264,252039,252422,252590,253219,254011,254012,257049,257050,257694,257880,257881,257882,257883,257884,257885,257886,257887,257888,257889,257890,257891,257892,257893,257894,257895,257896,257897,257898,257899,257900,257901,257902,257903,257904,257905,257906,257907,257908,257909,257910,257911,257912,257913,257914,257915,257916,257917,257918,257919,257920,257921,257922,257923,257924,257925,257926,257927,257928,257929,257930,257931,257932,257933,257934,257935,257936,257937,257938,257939,257940,257941,257942,258247,258455,258882,259600,259682,259683,260759) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.023517s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (9224,154176,171074,171146,133506,232754,109429,88821,160612,159719,104407,143445,205537,88271,7517,222875,246280,169873,19242,233780,103947,59310,85957,201345,186594,246016,136265,93042,231740,130720,195598,57673,253840,46481,32002,144363,179095,245081,168005,101273,212205,245244,173913,158704,188763,44818,85839,68532) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.012222s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` < 41110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004155s ]