SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453910 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453910 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474110,893595,846438,912757,246008,770012,209157,362326,224966,385780,959165,392589,662795,104314,636682,1033010,627842,515952,448497,46312,234730,943695,117518,591451,959061,648922,91061,906456,672959,135067,283575,1023215,575311,838544,133223,233990,401125,381867,591162,324129,802917,311911,750019,116976,333847,255105,835088,126628,748875,254538,42931,293289,490485,839058,988482,777188,189427,180889,136623,332243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]