SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003602s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397541 LIMIT 1 [ RunTime:0.001376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397541 [ RunTime:0.003562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401444,1045111,572900,547964,461061,238151,327625,1016997,139010,468236,308515,942320,528074,624990,873196,336300,1022867,226927,661064,563361,374622,471423,150337,725443,265373,431212,94585,989215,359500,644405,430093,381618,602230,974164,554972,315669,1003648,156310,222210,165660,76625,513857,304060,10997,889550,526863,678161,531899,658566,257388,237002,904939,159134,124716,733839,30864,947792,185358,459451,857200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]