SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489412 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489412 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925442,736941,28867,994253,919753,916577,480702,160422,381247,53234,186639,750394,735835,602659,583822,370835,803231,651755,604957,318121,879400,462151,854012,174652,747018,234679,46127,444150,720447,375229,54038,978212,690184,878199,927175,9479,918181,941452,272192,774746,370408,163839,752912,722109,927147,661905,5532,826229,637422,798370,359103,1007451,724363,642215,643736,830379,1033734,618537,108395,485152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]