SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415204 LIMIT 1 [ RunTime:0.001486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415204 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705357,905345,62698,850965,322355,230006,419508,3046,303609,707820,109642,266468,847608,217233,1000265,16175,89568,201086,457750,648589,470692,970969,549208,247056,544729,31804,471630,61138,686460,600966,877127,605208,152912,157613,857753,513784,690184,1028022,979430,40163,971369,820060,581750,525704,175957,348889,255650,512516,313316,864469,149135,504672,995139,375792,13528,446160,489400,486672,659562,722849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]