SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584954 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584954 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446924,31373,269811,191472,10875,365600,378795,807825,985048,808056,625585,462950,205171,252566,874226,397093,556104,205800,745003,43149,608763,786450,867236,610454,459228,16827,47203,632367,709875,979919,25386,955969,780332,497785,1036602,469058,93720,21617,725917,21823,201340,509008,585306,401428,913996,1044856,213770,652305,431303,716226,590758,248858,217613,382697,200018,28100,696625,546660,911441,122938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]