SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001653s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250601 LIMIT 1 [ RunTime:0.002127s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250601 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689993,584862,1012135,564021,548901,40408,310025,342327,224707,817352,340276,340954,185909,934331,454242,578068,1022486,280391,245062,219958,781463,1014100,918504,787837,906901,872679,244043,849379,766691,692946,411144,738666,950754,629564,690773,711688,839081,61114,518555,185760,861450,1034552,588875,925754,132690,227661,927020,795022,1031718,379405,217128,1012990,324963,581759,72605,235326,704296,1018363,749158,131157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]