SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511042 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511042 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277986,18423,934997,130504,582906,1019712,853555,800061,710770,806286,355251,523201,827846,60198,193599,155104,186157,82993,998647,468409,1047982,681007,561928,518455,54192,227209,719698,801552,1025233,39671,259320,573255,123857,330241,219054,175516,23393,736372,396698,750967,381493,779216,1030820,237330,198983,9394,21850,241498,951740,741571,537758,993534,209643,671863,443903,641229,86353,432971,945488,375273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]