SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597246 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597246 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466493,222406,183821,391984,3550,227200,909181,1046789,26689,452114,32355,580533,345227,522592,560228,52276,184893,1046533,285206,682790,543236,184178,291413,463164,492282,731502,54273,334212,203098,698099,20629,537862,180125,903605,428606,805550,645383,815510,320207,210395,309858,523354,66792,902579,492720,1039161,506387,143938,716343,895100,2343,646673,80327,291269,942926,1000570,163245,166605,19474,535281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]