SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 912203 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 912203 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4330,735257,588852,443917,750523,413082,559613,576440,663648,522832,815055,921798,95140,757227,823977,672005,704544,80138,1033425,282617,344572,786993,110680,331388,498793,940513,497212,282870,915133,289245,1001435,534612,949171,1034178,168089,19906,334235,27955,571740,55414,643834,478686,1014249,309202,794,170137,62273,350964,1030733,985109,1037959,530537,576903,249852,758650,238492,996866,595829,542536,1029582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 912203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 912203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]