SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 120043 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120043 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34100,810397,623154,567339,405651,428432,19367,974896,161909,43698,356668,910347,614461,341397,773288,784885,763107,140835,1036507,884500,916369,670259,483298,506329,920688,563648,379506,183475,633933,490470,473496,293867,123600,641998,956078,63246,429393,374790,100846,435035,849330,510254,803954,817221,520240,1001667,787466,216729,1015440,1023035,1005473,244700,163266,840650,198761,240528,34996,397165,492967,399062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]