SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505419 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505419 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244612,1017472,502519,449448,32981,52601,154629,1021497,703606,385798,504177,880840,365699,838403,910506,518555,742219,293247,673649,54455,755522,945950,807263,322140,889352,106929,642173,52761,632708,181964,908168,551277,875784,593722,134992,538991,919607,115993,269587,1011931,367625,375256,9381,5103,166054,634257,864229,36907,792454,872826,633272,108144,546691,171172,925759,809178,515579,302405,158200,84887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]