SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514575 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514575 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827606,869155,691211,11274,833537,406860,676430,462799,124339,459007,104205,1013591,976465,950969,649143,893274,674748,680527,113840,216725,34341,214937,753018,802340,146481,665554,789288,1003101,908382,879154,534343,614914,403534,7685,118281,918357,382108,687510,187282,1046055,1020352,646283,946871,715582,550443,382708,287469,992635,496384,1040267,305732,544006,207541,96848,1041087,47196,35332,135185,209256,10035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]