SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420445 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420445 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342112,258448,631237,1046863,283488,281592,617990,32192,456794,975970,558306,184209,84055,504249,718245,570589,69967,821178,420368,115020,647778,268815,963600,567333,667537,746869,35923,1035133,628287,940522,703125,86332,226356,252583,787021,754468,745209,650398,1022993,503698,879223,447609,938133,789387,309251,928716,218797,75418,993396,441092,256244,495515,250260,771484,683840,419862,1044071,218011,292069,913346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]