SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415072 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415072 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345814,644601,384686,522846,575598,961046,1010241,376226,394548,219130,140703,672104,48269,148964,806605,224272,547262,586372,805074,420694,255120,121136,124438,688496,1006307,102778,28388,635117,897397,978917,652423,516178,783601,4703,751464,553846,919559,292298,852625,542350,770307,993432,409340,716099,597032,792553,730748,800902,1031746,401025,896218,668577,761582,1004854,879992,938877,860616,735600,910285,580303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]