SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550642 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550642 [ RunTime:0.003693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311507,451904,406089,74171,875079,941299,678525,481755,104576,171829,697274,691688,629421,265122,394590,975856,562263,572286,91697,82419,808246,774938,410101,136722,173209,262126,173614,703772,853919,770342,594257,705070,978890,337001,917839,675009,149607,285332,1023679,881766,792202,189776,151768,95681,714129,240017,591275,784975,730716,1012206,520652,409028,265235,608619,272022,984839,297096,764809,983538,435846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]