SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022433 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022433 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92975,954941,482770,396889,444898,102452,713121,769118,784055,267166,11662,275582,120271,309156,844676,369753,72945,1021980,795088,688991,1008751,252569,286192,579902,486733,22716,245088,885856,919846,963822,1048257,373775,798789,17055,123619,160058,826164,913070,339496,39707,74367,979635,53564,545043,438650,233129,478453,943353,209034,631121,170519,174311,642222,555629,997029,591562,972795,275703,143674,533976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]