SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005940 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005940 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41222,601466,981989,25884,1027314,904198,772775,792797,432771,598072,920048,604099,54792,66631,539288,528151,227900,315876,890077,907808,486970,437790,911178,17473,1023846,397375,404458,967045,710802,1047803,908321,48192,586242,836874,11895,269826,815237,330487,818485,275204,273866,803589,1045744,395133,983609,116602,548095,184846,811451,108565,567606,416599,727139,10069,353008,603245,654211,268914,982265,556329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]