SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467748 LIMIT 1 [ RunTime:0.000725s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467748 [ RunTime:0.002344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547,618582,751337,786501,398767,401910,817612,49447,767183,542909,814219,402673,968070,93797,353625,965231,523142,828806,276073,809244,967383,980663,137343,190540,354523,427824,824754,988173,331255,411616,582358,122971,536310,194685,389637,506909,535711,504362,150794,722530,649284,567324,279696,247544,187557,369205,301576,852660,878798,295051,845913,864987,9167,331133,44553,411075,607580,794986,719441,826144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]