SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480907 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480907 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11486,714237,39744,889971,540123,572254,1006078,334034,737569,240668,850738,604299,52706,381008,615934,286683,539277,690752,314642,428949,1022396,717728,99241,373696,163681,862221,16637,130432,168879,910073,732593,566468,426167,480832,476851,202741,88181,125721,567205,408485,369007,848408,281945,249281,844295,574342,310340,164954,752974,913852,520004,677056,781303,825286,282457,576878,91021,916848,364164,489497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]