SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533659 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533659 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019101,974581,440649,280009,425597,272022,45469,137101,548127,208014,670741,547801,391492,327,130410,197271,592225,200928,552024,480893,746436,942656,347260,546118,555236,307511,827575,310916,562009,172387,597901,813364,267568,1018846,408552,514602,195768,983926,590985,977601,16011,920833,761,40789,851359,70075,642354,133821,226634,524669,81217,991561,719304,675794,433910,472915,857429,929362,723872,623845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533659 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533659 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]