SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58175 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58175 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254072,701689,184493,442767,709406,827448,358536,126405,92460,470046,87733,105292,1017486,68806,315725,306522,320946,951234,270961,586145,177530,528686,235120,840293,646682,223064,276711,845383,489917,952890,219704,180122,114197,798977,605137,687023,256545,79229,97205,55305,955207,598733,199426,699191,946760,287278,568004,805107,295389,713535,491216,73480,4049,728310,965529,849128,605917,906830,832740,1037072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000698s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]