SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001995s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 931998 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 931998 [ RunTime:0.004940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603254,238505,432501,808325,684228,431358,799061,436930,643284,958791,456442,649578,345586,31040,986469,428752,287617,815976,297475,117783,245214,137324,87967,103259,738401,140935,1028659,662352,408809,90702,466560,701820,498570,442798,1044427,352897,774054,889904,230611,319082,349235,482013,977178,260629,799427,531053,63086,701694,452604,234692,855395,198323,811692,371040,254233,236301,59790,670818,623082,725079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 931998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 931998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]