SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482213 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482213 [ RunTime:0.002567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454957,338440,930990,623725,746470,815954,744288,1047403,286105,1000242,229441,436055,694173,261616,87490,162774,59108,205536,402879,59652,227524,209388,495971,930420,343574,766535,485862,701995,643601,557346,817127,421022,809089,697481,198900,737656,539697,130643,372038,619308,53064,205297,707940,295598,514367,824955,476042,849771,320159,273607,137835,744619,168642,327045,494041,995077,598754,37468,562361,373300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]