SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51602 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51602 [ RunTime:0.004690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18802,743125,269131,767075,368312,870816,123534,413324,627237,603567,735274,291377,568690,485745,359275,927770,637241,830585,180836,993325,401455,715101,811508,388978,946770,339666,350426,965495,50862,668740,272691,340806,598449,373625,1041331,515454,929405,109691,180788,272954,661769,873231,125159,826207,833083,617332,476880,971897,66243,541150,159242,366053,331707,682370,231538,392007,772664,247995,873210,317151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]