SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266823 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266823 [ RunTime:0.002201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373812,222540,1010431,1036204,97515,354088,163424,719369,821729,919288,318303,586471,80355,860541,709044,493446,103250,400280,478712,702958,518055,914876,691022,455269,887586,819195,525644,161661,995702,300846,180208,747101,419914,884789,806187,476749,222074,372774,747226,144396,662383,793460,327222,418084,835600,689645,936836,193345,64592,47148,678384,290861,334990,985831,263485,627829,677324,523414,595697,814223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001156s ]