SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263612 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263612 [ RunTime:0.005839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237611,112222,106687,177368,470614,583104,780948,120048,374614,141700,524573,24566,389585,596360,384512,666050,486765,502760,437210,643960,140564,282383,140580,902299,806229,660642,853745,978609,525231,285995,6110,210436,857609,521673,843129,337987,221245,965824,83239,550876,343400,949521,1042420,126936,136257,644349,267202,2961,1034888,604985,383524,362034,116972,109590,83405,338194,645307,13902,305372,78233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]