SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111354 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111354 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375998,337314,397451,506893,501343,1002106,456814,524621,441996,159132,7597,500240,611264,1039928,515298,525683,505272,700667,340072,269290,958786,465199,137280,867236,131991,446943,179370,871798,796600,984022,80251,538487,129180,555113,418512,889607,712788,484835,622316,358646,35471,505653,167796,430731,394400,33396,298941,553743,270467,962494,93960,422720,565390,634412,694664,296302,342724,951271,220694,617057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001357s ]