SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507038 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507038 [ RunTime:0.002472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843106,105630,1010976,464833,612987,164486,874880,206261,378711,230953,37591,805783,1026596,713053,604300,6341,470664,594368,816640,652344,551252,968223,525776,83573,1019929,486616,300629,987079,13919,557703,544897,658722,737888,431608,491976,941570,239995,508314,495125,458708,202182,793999,299604,152219,710821,791352,284839,247701,802192,299045,955025,774111,451249,577651,464068,205232,638472,131167,752397,794837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]