SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41926 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41926 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39311,736723,629469,671344,904544,510731,814389,907278,998616,179369,961597,480138,741568,811577,243290,268052,483410,161718,876235,949449,979020,242848,457984,953830,193318,413931,686636,292270,41736,353677,493512,768037,573817,108353,328393,694382,606479,186481,160029,894325,163736,402597,1010960,318810,576969,451395,901439,1039447,1017712,883866,506569,779293,544098,244629,819036,183606,353619,13667,741339,476361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]