SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804040 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804040 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257561,1008390,140254,729044,972778,580644,512320,340176,591306,810055,388494,841044,533972,197003,247357,358343,942210,184265,888045,607441,793573,656100,857720,6795,1041329,509676,659224,623794,623377,965283,872287,515546,32962,707377,656516,1032165,904025,409481,483093,35533,401770,330856,738252,324148,554748,478954,959111,371948,344748,39546,906480,831465,915592,633293,959574,433398,402246,1031368,44909,975124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]