SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 384189 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 384189 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559473,1018632,591120,670217,770315,211848,165189,706728,80591,59436,734127,192400,998011,117511,514084,980434,880961,858307,149632,723133,1036808,417784,473942,886724,707038,481949,217353,559912,930872,607702,757511,929195,824337,303624,30158,242181,627401,872606,22329,991726,732203,612064,1001887,306217,456304,394311,444254,564247,344146,432941,559069,580153,144754,539757,504253,773265,303087,465843,956221,110502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 384189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 384189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]