SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505432 LIMIT 1 [ RunTime:0.005435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505432 [ RunTime:0.006157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496595,189381,1009360,560128,249911,275085,667666,579322,329643,1020504,608892,873642,124354,544998,97681,863328,667699,452084,601817,46230,815351,657876,220677,83985,899478,488740,517379,418410,495875,311653,302262,30185,341510,266380,771052,735257,249116,640237,710995,212797,1232,600018,870190,319466,386072,894269,947707,236538,652146,779322,210979,335981,368214,756726,78630,190556,25496,1507,194795,872062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001926s ]