SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280457 LIMIT 1 [ RunTime:0.000668s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280457 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124531,230720,183082,836866,722834,487318,215115,679618,401591,646496,12970,890096,372015,64037,986575,1040431,533396,379519,162656,97874,792219,608256,405260,62853,339299,43409,180324,957603,490631,1025700,213672,260482,1008716,19894,624303,606453,408348,825265,479990,1011451,402603,114594,306226,974553,924814,500305,418403,717986,278817,856297,1037982,152978,744664,236683,962042,626459,1037427,477908,587457,411833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]