SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518864 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518864 [ RunTime:0.006541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880872,27770,1037109,409203,23798,486997,45591,675547,773909,59802,149175,996808,356125,197483,769703,845267,194308,556353,208717,118155,66089,298649,158561,253818,829675,274747,103262,1036420,93490,251443,866791,630328,224664,983249,443836,514016,739375,142972,248036,811980,923023,132059,573485,905806,27734,619517,856316,578912,1011255,265624,763197,84920,474047,177106,842796,775899,258745,17580,507728,172871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]