SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460915 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460915 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512989,145450,112121,130780,205616,287976,257470,972599,875906,134766,45460,41563,794134,794537,505645,983867,717946,469984,974781,1002915,309987,236402,986392,1046738,156258,288013,894865,47887,543941,62460,424758,579526,580146,634080,385788,527903,592121,397456,1033610,797554,690360,986214,630659,528282,750849,951344,87492,976341,23349,983842,761744,249873,499281,874532,783880,499354,150922,833846,904518,229852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]