SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416804 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416804 [ RunTime:0.003412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112366,727674,302242,530631,685757,786530,198969,856931,994620,610036,872457,1040209,238351,418877,682799,845182,262829,665912,368789,590416,946643,291077,255415,256359,540124,247072,939034,403664,250847,597277,754768,412223,358132,507792,234648,370435,112820,660643,709095,428080,530324,391709,650565,444085,790730,651158,995659,317735,477729,556043,323257,469263,177175,654849,1037604,975578,549343,940979,447415,789834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001267s ]