SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484218 LIMIT 1 [ RunTime:0.000635s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484218 [ RunTime:0.002774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618134,558280,765236,547800,659484,1036314,709374,322944,307904,221369,297878,259766,657310,106821,348066,848218,929556,722507,476859,88778,407574,951068,995225,187432,280062,546605,734614,679468,564024,536390,310348,158009,555208,238221,840510,174485,575960,953885,392775,478490,863788,818037,939756,578265,812122,483738,566613,521834,6578,531959,760243,418009,556312,87658,624226,616118,548687,497277,672197,747012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001048s ]