SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254012 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254012 [ RunTime:0.002536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710776,662250,512711,317827,606304,133292,441185,777381,27125,218342,614101,470214,197707,99503,423685,1018595,481311,51584,134938,337229,874562,531658,292517,346753,440011,579775,724218,655718,969621,579469,426197,435151,950589,557572,69557,175312,675625,406288,554504,417107,750519,839996,68605,314094,577965,235784,491470,22347,746225,761050,31125,275068,234504,708668,997533,41505,789979,213610,571944,588619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003563s ]