SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 355674 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 355674 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367847,243353,190871,481771,918741,323514,25691,743985,581525,998104,275814,230911,92262,739967,736215,17861,188161,958392,872139,500395,986815,950058,895968,233129,320288,46478,771806,182962,472148,923705,80790,137290,70968,756227,62402,577867,345336,881076,393728,868561,64350,913536,733941,254423,82522,789827,223402,395997,918034,967428,674666,171554,356290,958402,1027744,403148,196816,834643,14596,348122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 355674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 355674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]