SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033639 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033639 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273218,203385,508782,717879,245706,485078,232763,526631,39886,37943,339239,442340,970728,216715,34374,566764,192167,718540,199599,209970,338047,275941,894877,45401,912463,386489,318063,920564,865753,435102,739832,813186,738198,769762,967940,820683,1024729,267999,640366,788914,483595,642562,1013334,139773,364434,17733,182485,740147,58595,985148,351784,823610,328608,891995,210042,1027054,646418,394786,878807,884923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]