SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533221 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533221 [ RunTime:0.003787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660751,297730,743758,118205,1026522,324522,236234,732491,750081,959479,522249,376457,704271,57148,142355,477455,945142,901154,415688,776794,264650,724344,473100,166321,755314,639566,85763,387187,532045,847019,325340,494540,558346,732692,856435,518464,365355,802463,580892,23698,781484,185155,361722,647482,157702,831151,266970,902948,61341,400847,156153,853200,698134,606021,944110,675163,17954,378286,691281,88610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000765s ]