SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418861 LIMIT 1 [ RunTime:0.002383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418861 [ RunTime:0.007343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420649,803714,897099,649044,234408,962811,1017968,405482,292116,846578,827279,505586,559369,141531,477079,252050,422481,366532,202226,1028424,976344,248189,256856,839320,1001163,862728,263438,167452,44578,353480,508016,586999,43940,152911,591604,583381,779871,880578,714250,537803,131913,1037958,1012119,1017714,967241,616169,108439,620613,618786,702704,580546,964246,369329,105964,603948,333090,922320,388208,233777,558077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]