SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420039 LIMIT 1 [ RunTime:0.004541s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420039 [ RunTime:0.011229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308732,569566,404544,986013,446638,241241,741851,1025968,924803,991410,243970,796924,55031,633633,167705,968066,458096,740430,209935,204890,223307,719523,780261,383696,252965,98729,222121,120230,401419,46159,679889,415883,491239,144117,343455,713535,665731,191264,392843,455473,133975,423263,803331,982980,754911,178708,490181,1015375,376213,750727,528440,188287,697394,723407,833334,952940,958300,880140,1033548,799222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006326s ]