SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534591 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534591 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723623,982964,852515,540861,166046,45037,990880,742487,207914,708589,186109,217509,649995,636499,188203,945774,208290,126138,334825,401617,310867,695474,60990,2320,834361,651192,794241,846336,157367,911875,279971,343004,747941,635851,407928,269104,575230,788212,651664,309682,638992,552256,459070,686510,872090,806443,380569,150121,675803,833872,960961,169907,602393,885065,496774,71892,928724,1027646,108072,824313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001209s ]