SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036985 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036985 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916522,264527,234621,193241,346864,565286,486616,744831,973618,742909,749490,435649,300545,641450,521721,763094,533603,441617,453493,631242,615475,151695,658365,606493,493228,137735,929274,738877,110511,617743,217495,942294,844507,735395,844090,5888,294776,132939,539787,144603,595899,313988,220250,183249,857736,292976,775302,814937,431544,182864,712821,726042,142143,1028707,955813,101223,108880,620390,451224,6903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]