SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047593 LIMIT 1 [ RunTime:0.001000s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047593 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770644,652048,309246,547240,225569,241343,50221,657178,870297,851214,766165,135873,43527,245204,206303,947749,559954,678007,646055,203045,970502,741438,388798,393248,765973,928831,50457,119924,362534,442199,423688,539660,502063,1039703,721460,514342,550649,389281,196281,251237,139816,1035120,98290,796435,803557,433960,610160,286355,113387,254980,111418,403254,986382,911769,738396,482108,220191,652291,180173,524405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003043s ]