SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354536 LIMIT 1 [ RunTime:0.001872s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354536 [ RunTime:0.002308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398345,848160,478891,92948,752454,490136,40940,932662,207423,24703,33431,569003,917500,678585,513295,103527,510451,18800,835611,164812,538361,518349,199661,902104,187054,925361,635310,633443,632929,762338,882272,998240,889330,263414,387695,408186,689842,850613,410686,677012,301429,589920,22585,117269,816039,150796,344298,441203,76467,54631,846744,1032293,923004,163141,22596,862628,426986,408301,769733,1002230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]