SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103481 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103481 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589529,929629,234271,440682,230571,1004331,1045289,509499,526402,801596,268137,402208,1003535,186030,384059,693430,584285,1091,97786,417156,749234,414242,302623,1040065,960067,358794,1024425,505866,260099,85361,200982,402563,543587,31639,716694,316818,71679,874837,398278,861510,31502,198176,657193,844334,301008,846946,164237,839559,788478,986861,675028,1008338,52912,524112,843419,119321,25627,51975,260190,666293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]