SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367582 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367582 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152006,592529,241682,235992,827232,446489,147939,406688,475354,676431,36018,499649,447487,49249,642641,249556,927984,800936,56907,924507,729691,62444,674159,449033,1026547,971672,448744,778259,609048,333963,1025188,50556,434309,124293,997390,108974,412946,728516,896625,673443,887262,594255,83480,588316,55040,752406,37523,1012220,387453,965875,856566,683774,370352,393385,534794,212088,338346,614277,115100,911028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001199s ]