SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407143 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407143 [ RunTime:0.002867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955381,624660,459840,789512,296001,136204,527772,96431,958128,925202,161863,680481,58408,238647,649049,390808,567405,844994,32681,820990,454832,112439,1008027,552490,585592,276950,280451,146578,322035,480135,295419,34109,284794,39686,35752,598801,1023971,337470,526438,872129,963485,398697,65761,252573,928562,735571,824390,476967,275897,459665,581424,648140,463697,51397,518984,152087,799946,546711,1011186,473921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]