SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292040 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292040 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524291,375429,385942,71714,889587,52988,602212,26503,456505,448732,679816,621398,232725,859530,373244,77032,371632,559873,589933,85056,738178,1007294,161185,480432,339633,987495,396764,342684,801092,712399,1031279,230618,942287,579697,486146,892331,422693,920895,623896,838258,808430,982226,154125,176846,398499,658957,510833,15732,777282,559405,525506,120473,557891,231740,410688,1013618,962412,131888,21340,660634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]