SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9803 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9803 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291438,924784,561859,1006023,933768,951634,992174,159986,862642,672245,455095,603920,710282,468587,711704,893978,989642,448682,168519,901585,949435,643884,872264,364438,337999,573156,322001,566290,585435,729392,684659,447420,911953,161985,221365,705779,216408,52435,170534,540323,680823,64060,173639,738128,418304,466932,607386,690692,52317,426354,494808,972139,656897,735638,459327,336482,860262,677995,510102,570954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001397s ]